Is it possible to create multiple pivot tables using the same sheet?
Options
I created a pivot table using a sheet, and it worked very well. However, when I try to create a different pivot table using the same sheet, the "Create" button just continues spinning. Is it not possible to create multiple/different pivot tables using the same sheet? In this instance, we have test scenarios in a sheet, and I want a pivot table to show "Test Scenario by Assignee" and I also want a pivot table that shows "Test Scenarios by Functional Area".
Answers
-
I create reports to use as the source for Pivot App (actually for all the premier apps). This should provide the flexibility you need with multiple pivots.
Kelly