Aggregation on aggregation

[KharansuESSPL]

Hi,

I have a situation where I need to calculate 3 columns which I want to show as pie chart on a Geomap.

eg.

Sum(unitprice)*Sum(unitQty) as [Total SalesHealth],

Sum(unitpriceCorp)*Sum(unitQtyCorp) as [Total SalesCorp],

now after this both of these have to be included into one column in a crosstable. But the problem is when [Total SalesHealth] and [Total SalesCorp] are used individually in a chart in the chart where their calculations are directly written in the Expression window (fx), they show correct result but when they are included in one column and called upon as a measure, they give different value as the values get aggregated again.

Please give a solution for this. Attached an excel for reference.

Note - in Geomap's pie chart we don't have option to do the calculation for each column 

[simonaubert]

Hello.

Could you please provide some screenshots to clarify ?

Best regards,

Simon

[KharansuESSPL]

    

Basically I want Totals of both the above columns to be same. So the Total SalesHealth - Calc is the value I get for a line chart or any other chart where I can directly calculate it in the sheet but Sum([Total SalesHealth]) is the one which 'am calculating in script window and again calling here as I should not calculate here but the problem is I can't call it as a dimension too

to simplify - How can I put two different calculated columns in one and show on a pie chart layer on a geomap?