Hi everyone.
I am currently having a problem trying to get my statement for Last Year values to work. I want to obtain the Cost Value for my Last Year data. It works just fine with this equation:
(Sum(FOODCOST*Sum({<CalendarYear = {$(=Max(CalendarYear)-1)}>}QUANTITY))
+ Sum(ComboFC*Sum({<CalendarYear = {$(=Max(CalendarYear)-1)}>}ComboQty)))/1000
but when I adopt it to a pivot table and use it for other fields like % to Sales, I realized I had to have an aggregated function for the groupings. So I came up with this equation:
(Sum(aggr(FOODCOST*Sum({<CalendarYear = {$(=Max(CalendarYear)-1)}>}QUANTITY), PRODUCTDESC, BRANCHNAME, COST1))
+ Sum(aggr(ComboFC*Sum({<CalendarYear = {$(=Max(CalendarYear)-1)}>}ComboQty), COMBOPRODDESC, BRANCHNAME, COST1)))/1000
*Where COST1 is my Inline Table for Dimensions of the pivot table
but the resulting value is lacking by at least 2000 (in P(000)) from my target result. Any ideas?