PDA

View Full Version : VBA for Pivot Tables and Slicers



TinkInc
11-09-2015, 07:32 AM
I am using a pivot table to create a dashboard, however the slicer and pivot table only summarize raw data. My currently graphs when no slicer is selected or only a few are selected displays summations of the remaining non selected slicer filters. So my graphs have 1000% showing. Is there a way to block or even just limit the graph display. In the future I am trying to create a dashboard that allows the user to scroll through my oracle roll up summaries. The pivot table works but it always wants to add additional calculations instead of letting the user just display roll up variable existing data.
Thanks for any guidance on this.

Paul_Hossler
11-10-2015, 02:33 PM
A sample WB will help with enough raw data to demonstrate the issue of what you get vs. what you want would be helpful, even if you have to mock up the results you want