Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
The set analysis I'm using:
Sum(Aggr(nodistinct Sum({$<Type {'Daily'},ProductGroup=,ProductSubGroup=,ProductDetailGroup=>}SalesCY),Store,DateCY))
Photo shows where I'm seeing inconsistencies for column 1Gross Ticket Contribution. Those items highlighted in red are the correct value for Store #1, remaining items aren't.
You may not need an Aggr() here. How about this?
Sum({$<Type = {'Daily'}, ProductGroup, ProductSubGroup, ProductDetailGroup>} TOTAL <Store> SalesCY)
or
Sum({$<Type = {'Daily'}>} TOTAL <Store> SalesCY)
Add other fields to the total qualifier if needed
You may not need an Aggr() here. How about this?
Sum({$<Type = {'Daily'}, ProductGroup, ProductSubGroup, ProductDetailGroup>} TOTAL <Store> SalesCY)
or
Sum({$<Type = {'Daily'}>} TOTAL <Store> SalesCY)
Add other fields to the total qualifier if needed
Removing Aggr() and adjusting to the Total <Store> qualifier you detailed worked perfectly!
Thanks, Jontydkpi!