How to create an average aggregated dimension in a pivot table

[BNolan]

Hello, 1st time post...  I have a pivot table in Qlikview showing the product costing by month.  I need to create a aggr dimension of the average cost. 

I'm able to SUM all of the monthly costing values with

=num(Aggr( Sum(Costing),Product ),'###.####')

But I'm struggling with find the number of months to do the division...

I'm  using...

=Aggr( Count(Costing), Product, MonthYear )

Any ideas?  I'm baffled!

Thanks,

Bernard

[MayilVahanan · Accepted solution]

HI @BNolan 

For find the division of the month, try like below

=Aggr( Count(Distinct MonthYear), Product)

[BNolan]

Thanks so much.  Works just as desired!