RachelImamoto
New Member
- Joined
- Oct 19, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
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!
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!