Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Try with total keyword
Sum(TOTAL <Date>{$<%PID={5}>} Volume)
Use this Expression without using calculated dimension
Celambarasan
Hi,
try with this
$(=aggr(sum({$<%PID={5}>} Volume),Date)))
Celambarasan
Hi,
Assign this to a variable
vTest = Sum(aggr(sum({$<[%PID]={5}>} TRx_Volume),Date))
Now use this variable in the expression as
=vTest
Now it displays all the cells with calculated value.
Hope this helps you.
Regards,
Jagan.
i can not do that because for different dates different values are there but variable will store only one particular value at a time.
The final table should look like this
Date Product sum(volume) sum for product 5
1 1 5.11 10
1 2 5.40 10
1 3 30.5 10
1 4 10.78 10
2 1 19.67 20
2 2 52.4 20
2 3 30.45 20
2 4 10.45 20
Hi,
Check with this
$(=Sum(aggr(sum({$<%PID={5}>} Volume),Date))))
Celambarasan
Hi,
Try with total keyword
Sum(TOTAL <Date>{$<%PID={5}>} Volume)
Use this Expression without using calculated dimension
Celambarasan
Thanks Celambarasan. It works I was struggling to get this correct since last 3 days. Thanks a lot