Pivot table with Red Green Amber Slicer and return Header

Solved the post. created a new table that i could use pivot tables with

Hi guys

I have a pivot table that is calculating savings per area and within that, names:

Attachment 859509

It is calculating the savings from the savings sheet

Attachment 859510

I also have a name overview sheet.

Attachment 859511

If I click the Green slicer in the first picture. I want, under elise ford "1D"and "3C" will appear, Israel summers "2B", etc.


Is this possible?

If you have M365 you can use GroupBy function to do it as well.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.