I am working with categorical data - think of a survey with ratings from 1 to 5. In addition to the counts and grand total, I need to be able to ad a percentage to summarize the top two categories.
example.png
My true data includes several nested groupings in the rows, so it would make things much easier if I could add this into the pivot table rather than just having a manual calculation off to the right. That would accommodate new groupings that might appear or expanding/collapsing sub-grouping automatically.
sample.xlsx
Bookmarks