ashleywanless
Board Regular
- Joined
- Aug 4, 2009
- Messages
- 158
Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’m having issues with a pivot chart which has source data from multiple consolidation ranges. I have 4 sheets with data in them, 5 columns in total (A:E), all 4 sheets have exactly the same format, column A is Task, B is Time, C is Business Area, D is Administrator and E is date.
<o> </o>
Now I want to use a pivot to analyse this data but when I go through the multiple consolidation steps to produce the pivot the pivot table only shows row, column and value in the pivot table field list. Why doesn’t it show my column headers in this field? Is it possible to do this as I wish to analyse task times by business area.
Would i need to write a macro or use an excel function to collate the 4 sheets into one and run the pivot from this?
Thanks
<o> </o>
Thanks
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’m having issues with a pivot chart which has source data from multiple consolidation ranges. I have 4 sheets with data in them, 5 columns in total (A:E), all 4 sheets have exactly the same format, column A is Task, B is Time, C is Business Area, D is Administrator and E is date.
<o> </o>
Now I want to use a pivot to analyse this data but when I go through the multiple consolidation steps to produce the pivot the pivot table only shows row, column and value in the pivot table field list. Why doesn’t it show my column headers in this field? Is it possible to do this as I wish to analyse task times by business area.
Would i need to write a macro or use an excel function to collate the 4 sheets into one and run the pivot from this?
Thanks
<o> </o>
Thanks