Ajeet Mahajan Member

Great! I apologize for the misunderstanding. It seems I misinterpreted your use case. I thought you wanted to display a unique row for each position ID with its corresponding fee, along with a grand total for the overall fees. I'm glad you were able to find a solution that works for you!

Thanks for reaching out to our community forum. In most data visualization tools, it's generally not possible to combine distinct values and overall totals within a single column in a pivot table or similar structure. Here are the common approaches to achieve this: Separate Columns: Create two columns: one for distinct…