26 Juni 2012 11:36
I've recently begun to work on Power Pivot. I have PowerPivot tables and Pivot tables created from them in turn. There is a slicer A on the main Excel sheet which powers all the pivot tables. 'A' takes values from an external source, Sharepoint in my case. I would like to not only slice the pivot tables but also the Power Pivot tables based on the slicer values.
Is this possible at all? I've looked through some solutions. Apparently, linked tables cannot be created from Pivot tables so I've run out of ideas.
Any help would be greatly appreciated!
27 Juni 2012 5:08
you can use slicers to slice pivot tables based on the power pivot tables but I don't think we can slice power pivot tables directly.
Plaese mark as answer if helpful
- Ditandai sebagai Jawaban oleh Ambac 28 Juni 2012 5:48
28 Juni 2012 5:48Yes, I thought so too. Thanks for the reply.