Hi everyone!
I would like to show the same set of data grouped by two criteria but subgrouping them.
When I put my data in the data area, and the criteria (crit1, crit2) in the column fields area I get the values grouped first by crit1 and than subgrouped by crit2. What I would like to see is grouping by both criteria independently, first by one and than by the other, without subgroupinig.
Hope it's not too confusing :-)
Up to now, I've been solving that by multiple pivot tables. Is there any way to do the same? Thanks!
Bookmarks