Help with Aggr

[hopkinsc]

Hi,

I can't get my values to match. in the attached, the bottom table totals should match the top table. the top table is by customer and the bottom table has a drill down of various categories and product.

If i don't select anything from the bottom table then i get a total of 49,738,890 but the top table states 44,848,395.

and when i select the drill down in the bottom table, 'xyvj' for example, i get 1,644,720 but the top table states 1,616,856.

I am not sure what is going wrong. can anyone help?

[krishna_2644]

Not able to open your app as i am using a PE of QV.Any alternative?

[hopkinsc]

Hi, thanks for your reply. unfortunately not, you will need a licenced version. thanks anyway.

[sunny_talwar · Accepted solution]

May be this

Sum({<Period>}Aggr(If(IsNull($(vForecastSales)), $(vTotalSalestoLastPeriod), $(vAnnualSales)), SubCat, SubCat1, [Item Description], Dim))