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

<colgroup><col><col><col span="13"></colgroup><tbody>
</tbody>

<tbody>
</tbody>

 

[Andrew Poulsom]

How did you manage to get two identical row labels?

 

[nicci113]

How did you manage to get two identical row labels?

This is the airport data, A6 criteria has two different names within DB which result in two different record.

 

[nicci113]

This is the airport data, A6 criteria has two different names within DB which result in two different record.

One A6 has extra space and another don't which brings two records

 

[Andrew Poulsom]

Can't you remove the extra spaces from your source data? If not you will need to sum the results of two calls to GETPIVOTDATA.

 

[nicci113]

Can't you remove the extra spaces from your source data? If not you will need to sum the results of two calls to GETPIVOTDATA.

Not really I did tried that as well. I tried to sum of getpivot data and it seems to be working. It was more to do with when i was moving formula over it wasn't calculating the other fields but checked other forums and found the solution, thanks for headsup

 

[nicci113]

how to close the thread any idea, can't fiind the option