Problem in Expression ..

[#1]

Hi Frnz,

I was stuck at small expression. I need to show sum(L2AMID_VALUE_USD) in the basis of L2AMID field. I have used in AGGR in expression. But it is not working.

Please help to find solution. Please find the attached QVW.

L2AMID ===> Account ids

L2AMID_VALUE_USD ====> Measure in USD$

[PrashantSangle · Accepted solution]

Hi,

Try Sum(Aggr(sum(L2AMID_VALUE_USD),L2AMID))

regards

[prajapatiamar38]

Hii

PFA

Is that you want

Thanks

[#4]

Hi Max,

Thanks for your reply. It is showing wrong totals. It is not working properly

[#5]

Hi - I could see two dimesions are already in use. While solution given by max dreamer should work, could you please let us know what is the expected result?

[#6]

sorry..It is working..Thanks Max