i do face a simple pivot table with months in the row (200201,200202,200203, ...). is there any way to sum up alle the data and put simply years in the row? (2002,2003,2004)
might be a small thing, but i can t find...
thanks!
i do face a simple pivot table with months in the row (200201,200202,200203, ...). is there any way to sum up alle the data and put simply years in the row? (2002,2003,2004)
might be a small thing, but i can t find...
thanks!
Assuming your months aren't real date values (as implied by 200201 etc...) then the quickest / simplest solution would probably be to add a column to your PT source that extracts the Year from the "date" number, ie if date numbers are stored in source sheet in Column A, and say first available column on the source sheet is Column D then:
A2: 200201
D2: =0+LEFT(A2,4)
copied down for all rows
You can then use the new column in your PT as your ROW Field (remember to adjust your PT source to include the new column, and likewise be sure to add a header to D1 so you can use it in the PT!)
If I've misinterpreted your data please post an example (remove/dummy anything otherwise confidential of course)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks