Can you post a sample trimmed down version of the pivot, recreating the issue.
Can you post a sample trimmed down version of the pivot, recreating the issue.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Hello
I have attached the file with data and sample pivots
If you see in the file I have 2 pivots for same Data
Pivot1 ---> Labels are merged and centered in both Rows ( Segment1, segment2, etc) and columns (01-Sep-2013, 01-Nov-2013 etc).
Pivot2 ----> All labels in rows and columns are repeated.
Requirement is that I want to create a single pivot with columns Labels as in Pivot1 (Merged) and row labels as in the Pivot2 (repeated).
Thanks
Kris
Posting Permissions
Reply With Quote
Bookmarks