Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use multiple page fields in pivot table
Hi all,
I'd like to use multiple page fields in a PivotTable, but I cannot figure out how... I created a PivotTable of multiple consolidation ranges (3). In 2 of 3 sheets I based my PivotTable upon, there are columns named Period. I want to use the Period-column as a Pagefield also. In my PivotTable I have a column which counts the costs, and one that counts all the budgets... but now that's for a whole year, and I want that per month. I already created 1 Pagefield per sheet already, I guess I have to create more from all the sheets, but this is where I get stuck. How to create the situation that Period becomes a page field? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interdependent page fields in one pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - Show Page Fields | Excel Discussion (Misc queries) | |||
Pivot Table Page fields | Excel Discussion (Misc queries) | |||
Pivot Table page fields | Excel Discussion (Misc queries) | |||
Pivot Table Page Fields | Excel Discussion (Misc queries) |