Hi
I have below data . I want to display Serial No & i want Total Amount Value shoudl be displayed only once in case of same multiple Document No. In below case 1,410,500.00 should be displayed only once.
| 5101210 | 15-07-2024 | IB-SG-12 | -650,000.00 | -39,000.00 | -39,000.00 | 0 | 1,410,500.00 |
| 5101210 | 15-07-2024 | IB-SG-5 | -650,000.00 | -16,250.00 | -16,250.00 | 0 | 1,410,500.00 |

Thanks
Sophia CarterPosted Mar 11, 2025, 5:52 AM
It seems like you're aiming to display a specific value only once when there are multiple instances of the same value present in your data. In your table, you mentioned that you want to display the Total Amount Value only once when there are multiple rows with the same Document No.
To achieve this in a programming context, you would typically iterate through your data, keeping track of which values you have already displayed. Here's a high-level example in Python to illustrate this concept:
In this script, the `set` named `displayed_values` is used to keep track of the Document No values that have already been displayed. This way, the Total Amount value is only shown the first time a particular Document No is encountered.
If you are working with a different programming language or tool, a similar approach of tracking displayed values can be implemented to achieve your desired output.
Let me know if you need further clarification or have any additional questions!