GetPivot Sum Multiple Column

[nicci113]

Hi there,

Guys, I have this work assisgnment where I have to extract data from pivot and display in combined fashion (below).
I can extract data and display using getpivot function but what if I want to Join A6 together and then display the result?
I also tried circular formulla but it doesn't seems to accept the value. Any help is appreciated.


Sum of Pax Column Labels
Row Labels January February March April May June July August September October November December Grand Total
A6 31542 10269 9518 9727 8159 8355 10087 9501 9766 10596 11577 11425 140522
A6 65388 60846 73843 42694 39413 40422 43421 44394 44395 45043 34485 35061 569405

[Norie]

What do you mean 'join A6 together'?

[nicci113]

Thanks for the reply!
If you look A6 appear two times. I want to combine the result of A6 and display in new file. Since its a pivot design I can't use sum function

[nicci113]

So for example A6 Should be (31542 +65388 )=96930
Hope this will explain better