Creating a 'set' of pivots

[bens1]

Hi there,

I have a dimension with values ( let’s say a,b,c,d,e). I have an ask from specific users to present them in very specific ways on the same viz on a pivot: first column would be the aggregate of the first three values (a or b or c should be included in that column or row’s results), then after that each individual value in their own columns/rows, then the next two values (d or e should be included in the column’s results), then individual columns for d and e. Has anyone done this kind of cohorting before? Any guidance would be majorly appreciated. Thanks in advance!