khkrishnakumar
New member
- Joined
- Jul 12, 2016
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hello,
I would like to know if there is a way to consolidate multiple pivot tables and get the results in the same format?
eg:
Sheet there are 10 sheets with the same data as below:
I need to consolidate all the 10 sheets so that the result also comes in the same format. When i consolidate i am getting the result in this format:
The alphabet under Area is totally missing and it is replaced by numbers. I want that corresponding Alphabet also.
Any way this can be done?
Thanks,
I would like to know if there is a way to consolidate multiple pivot tables and get the results in the same format?
eg:
Sheet there are 10 sheets with the same data as below:
Sales | Area | Number |
A | U | 10 |
B | V | 10 |
C | W | 10 |
D | X | 21 |
E | Y | 32 |
F | Z | 54 |
I need to consolidate all the 10 sheets so that the result also comes in the same format. When i consolidate i am getting the result in this format:
Page1 | (All) | |||
Sum of Value | Column | |||
Row | Area | Number | (blank) | Grand Total |
A | 0 | 80 | 80 | |
B | 0 | 80 | 80 | |
C | 0 | 80 | 80 | |
D | 0 | 168 | 168 | |
E | 0 | 256 | 256 | |
F | 0 | 432 | 432 | |
(blank) | ||||
Grand Total | 0 | 1096 | 1096 |
The alphabet under Area is totally missing and it is replaced by numbers. I want that corresponding Alphabet also.
Any way this can be done?
Thanks,