Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
The below espression works fine with a straight table, where Calendar.YearMonth is the dimension moved to the top as header. However when I change the straight table to Pivot, the AGGR part doesnt work and it simply shows the month values... Any ideas and suggestiong is highly appreciated.
=(sum(AGGR($(fnCashToMonthCV),Calendar.YearMonth)))
Thanks in Advance,
Mady
hei
just an idea
if you have other dimensions in the pivot table
you need to include them in your aggr function