Pivot grid looks great, however, our customer demands a different outout.
We are running the flat grid layout in Pivot with multiple options in the Rows.
We don’t want to show the grouped rows in the output, rather we just need the last row after the group.
Example: If there is a grouping done on three fields which is, Region, Branch and Name: for every record, we see two rows which are the grouped rows on Region and Branch
All we need to display is One row which shall have the output like this:
Region Branch Name Additional Fields for sum
Test R Test B Test N 20 30 40