I have 1 unstructured report with a lot of details. I have attached one sample of the report with the discussion post. So whenever I create the trap to get all the details depending on the "Amount" Column. My requirements are that I want just the "Total: and Amount" or the field rows for the Customer with the word Total in it and definitely the Amount associated with the customer. When I place the trap, the first 2 customers who does not have the total section should be blank on the table but it does happen that the First 2 rows of customers in the table view gets filled with "107.54" instead of being blank. How to setup a trap and how to rectify it with specific values. IS there a way to do some conditional formatting that whenever the system see total: with the amount, it should take up the amount and display it for that specific customers. Thank you for your help in advance. Really appreciate it!
