Pivot Dimension distribution

[agni_gold]

Hi Friends ,

I have one expression

((sum({$<_PFlag={'ORG'},FINANCIAL_ACCOUNT_KEY={'$(vKPI1AccountKey)'},VARIANCE_BASE_SK={$(vVariance)},ACTUALITY_SK={'AC'}>}VOL_PREV_AMENDED))/1000000

+

(Sum({<_PFlag={'ORG'}, ACTUALITY_SK={'AC'}, VARIANCE_BASE_SK={'AI'}, Priorities={'Harbin/Sedrin'},FINANCIAL_ACCOUNT_KEY={'$(vAcc1)'}>}VOL_PREV_AMENDED)*.59)/1000000),

First part belongs to sole other zone and second part belongs to some other zone , but when i put this expression in pivot table then there are two different rows are coming for both the part, i want to sum both value and assigned to first part zone.

Thanks

[sunny_talwar]

Try this

If(Zone = 'First',

((sum(TOTAL {$<_PFlag={'ORG'},FINANCIAL_ACCOUNT_KEY={'$(vKPI1AccountKey)'},VARIANCE_BASE_SK={$(vVariance)},ACTUALITY_SK={'AC'}>}VOL_PREV_AMENDED))/1000000

+

(Sum(TOTAL {<_PFlag={'ORG'}, ACTUALITY_SK={'AC'}, VARIANCE_BASE_SK={'AI'}, Priorities={'Harbin/Sedrin'},FINANCIAL_ACCOUNT_KEY={'$(vAcc1)'}>}VOL_PREV_AMENDED)*.59)/1000000)

)

Not sure what all dimensions you have, but you might need to add field names with the TOTAL qualifier