I have 3 columns of criteria that pull from our system that have to possible options of Yes or a blank cell if they don't meet that criteria. I want these to show up in the pivot table as columns so that we can see the subtotals for the values showing in the pivot table, but when I move the 3 criteria to the rows section of the pivot table, they are nested in the groupings rather than being on the same "level". Is there any way to change this? I also don't want to show the rows for blank cells (so for any of the entries that don't meet the criteria and have a blank cell). I can't change the way the data pulls from our system, so any workarounds really have to be in excel.
excel 1.png excel2.png
Bookmarks