Totals in Aggregation Function

[vikas_nandanwar]

Hi,

I am using below expression for Average Inventory =

Avg(Aggr(Sum(InvCost),DataWeek,OGC,[TransactionDate.autoCalendar.Month]))

I am getting the figures correct in OGC Rows, but my totals is getting average of all OGC.

Totals should be Sum of all the below Average.

I have added the screenshot for the same.

How to get totals?

Thanks,

Vikas

[mdmukramali · Accepted solution]

Hi,

can you try below option

Hi,

[vikas_nandanwar]

Thanks