Display Value Only Once

Question

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 Carter · Answer

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: data = [ {"Document No": "5101210", "Total Amount": "1,410,500.00"}, {"Document No": "5101210", "Total Amount": "1,410,500.00"}, {"Document No": "5101210", "Total Amount": "1,410,500.00"}, # Additional data here... ] displayed_values = set() for entry in data: document_no = entry["Document No"] total_amount = entry["Total Amount"] if document_no not in displayed_values: displayed_values.add(document_no) print(f"Document No: {document_no}, Total Amount: {total_amount}") else: print(f"Document No: {document_no}, Total Amount: (already displayed)") # Output will only display the Total Amount value once for each unique Document No 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!