I have a multiple calculated fields in my excel pivot table.
The field is in the values part of my pivot table and I sum them. I want to add a slicer to select them or not.
i.e. I want my slicer to select basically hide and show AA1,AA2,...,AA8 in the chart and table.
This is normally easy if the field already exists in the table, but because this is a calculated field I can not work out how to do it.
My data is attached.
Cheers
It can be done with Power Pivot but I don't think that is possible in your Excel Version
You need to use Power query to unpivot your original data in order to have AA1, AA2 as records in row. After that you need to create a measure as ratio between values and "n" column and create a Pivot Table from PowerPivot data model.
The query:
and the measure:HTML Code:
Formula:
Please Login or Register to view this content.
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks