Totals in Aggregation Function

vikas_nandanwar — Tue, 26 Dec 2017 05:08:19 GMT

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

Re: Totals in Aggregation Function

mdmukramali — Tue, 26 Dec 2017 05:18:48 GMT

Hi,

can you try below option

Hi,

vikas_nandanwar — Tue, 26 Dec 2017 05:35:37 GMT

Thanks