Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
anchor fields to pivot table (Excel 2007)
I have a pivot table that I create an IF statement against....to see if a
field in the pivot table has any data in it. The pivot table has 10 rows in it...so my field with the IF statement has 10 rows....and the rows in my pivot table line up with the rows the IF statement is in. The problem is that if I change the selection for the pivot table that increases or decreases the number of rows in the pivot table...the pivot table rows and the rows in my IF statement don't line up any longer. How can I make my fields stay in line (on the same row) as the rows in my pivot table? -- Thanks, Jesse |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Excel Pivot Table, Property Fields | Excel Discussion (Misc queries) | |||
Pivot table row fields limit vs. number of rows in use for Excel 2 | Excel Discussion (Misc queries) | |||
number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
Excel 2000 Pivot Table Calculated Fields | Excel Discussion (Misc queries) |