A very good evening all,
I have a data sheet which I need to pivot. A reduced version is attached.
I need to show sub-counts - i.e. the 1s and 4s in seperate columns.
It needs an additional column on the pivot to show EN, North and South added.
Plus, It needs it to contain all the columns in the original data
As you may have guessed, I am a pivot novice.
Cheers,
John.
Last edited by Johnmitch93; 02-01-2012 at 06:19 PM.
OK - Have I been a little unclear with the question?
It's a bit unclear, but if you put in the Sign in row labels will that display the info you are looking for?
I'll have another think about the question first.
Cheers JH.
John.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks