Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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