A general pivot query

[#1]

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

[lironbaram]

hei

just an idea

if you have other dimensions in the pivot table

you need to include them in your aggr function