I'm trying to get the total sales across all product groups to do a calculation of profit contribution. For some reason, I'm unable to have consistent returns across all product groups, which will, in turn, throw off the calculation.
Hi, Do you mean all values for store # 1 should be 13439? I saw that in aggr(), you also group by the DateCY, could you please try to delete this field? because I'm not sure why you use the DateCY, it seems like that in your table there is not DateCY as a dimension? Aiolos Zhao