I want to create a tabular data report that resembles the tabular layout of an excel pivot table where item labels are not repeated - so I don’t want like data to be repeated row to row. I definitely want to use the Toad data report because I am able to easily embed a file path in one of my columns. However, when I group items, even if I group all of them in the same header group, all of the grouped items appear 1 row above the rest of the data. How do I group items so that like data appears like the excel tabular pivot table?
This is how I want data to appear.