Is it possible to create multiple reports (charts, graph, tables) from 1 pivot table. I have multiple sites with different team and I want to create a report for different sites with different teams.
Why?
The purpose of pivots is the ability to slice and dice data easily. I always have a multitude of simple pivots on which I create my final report or dashboard.
In the end you can add slicers per team per site and keep a single pivot, but that's rarely ideal.