pivot table sum = 0

[#1]

Hi,

i have 3 dimensions in my pivot table

textvalue, salesid, itemid

my expression is

aggr(FirstSortedValue(COSTPRICE,-MODIFIEDDATETIME_INVENTTABLEMODUL) * SUM({<TCMSALESORDERYear={'$(vMaxYearOrder)'},TCMSALESORDERMonth={'$(vMaxMonthOrder)'},TCMSALESORDERDay={'<=$(vMaxDayOrder)'},TCMSALESORDERDATE=,TCMSALESORDERMonthYear=>}QTYORDERED),TEXTVALUE, SALESID, ITEMID)

my problem is the aggr function i dont get the sum of the column ??

can anybody help me ?

[jagan · Accepted solution]

Hi,

Try giving an aggregate function like sum() or count()

Sum(

aggr(FirstSortedValue(COSTPRICE,-MODIFIEDDATETIME_INVENTTABLEMODUL) * SUM({<TCMSALESORDERYear={'$(vMaxYearOrder)'},TCMSALESORDERMonth={'$(vMaxMonthOrder)'},TCMSALESORDERDay={'<=$(vMaxDayOrder)'},TCMSALESORDERDATE=,TCMSALESORDERMonthYear=>}QTYORDERED),TEXTVALUE, SALESID, ITEMID))

Regards,

jagan.