Extracting Data from a PowerPivot

[RachelImamoto]

Hello. I’m posting in hopes of an answer and some help.

I am trying to extract data from a PowerPivot to turn into an interactive dashboard. The kicker is that I want it to show text values and not totals. Every time I try to use the GetPivotData formula, it doesn’t recognize the PivotTable. I am at my whit’s end and feel like I have tried everything! At this point, I am using a filter formula, but I can’t manipulate it to be viewed in dashboard style. Please help!

 

[GraH]

Create the pivot and switch it to cube formulas
That will give you a clue.

https://support.microsoft.com/en-us/office/convert-pivottable-cells-to-worksheet-formulas-4ad90af4-20d4-4ad3-9b87-b3748bcf268d#:~:text=Click%20the%20PivotTable.,Formulas%20dialog%20box%20is%20displayed.