I am stuck with an expression which works fine when I filter the data and it gives incorrect numbers when I dont filter the data. Here is the expression...
SUM(Aggr( (Unit_Cost) * sum(lCount), ItemId))
This works fine, when I filter on the Field ParentID (Which is my only dimension). However, if I dont filter on the ParentID it gives incorrect numbers. I am not sure where is the problem. Unfortunately I cant load the QV document because it contains sensitive information. Can someone please help...?