Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I do Accumulate report by Pivot Chart like this;
I'm stuck with 'Sales_total_accum' => I do in If Clause; If(Accu<=Sales_total_80%,Sum(Sales_All),0).
But no number in 'Total' level, I would like to sum it up. So I need you suggestion and help .You can view my solution in attach.
Thanks.
Try this
=Sum(Aggr(If(RangeSum(Above(Sum(Sales_All), 0, RowNo())) <= Sum(TOTAL <Department, Category> Sales_All)*0.8, Sum(Sales_All), 0), Department, Category, ProductID))
or this if you have QV12
=Sum(Aggr(If(RangeSum(Above(Sum(Sales_All), 0, RowNo())) <= Sum(TOTAL <Department, Category> Sales_All)*0.8, Sum(Sales_All), 0), Department, Category, (ProductID, (NUMERIC))))
Try this
=Sum(Aggr(If(RangeSum(Above(Sum(Sales_All), 0, RowNo())) <= Sum(TOTAL <Department, Category> Sales_All)*0.8, Sum(Sales_All), 0), Department, Category, ProductID))
or this if you have QV12
=Sum(Aggr(If(RangeSum(Above(Sum(Sales_All), 0, RowNo())) <= Sum(TOTAL <Department, Category> Sales_All)*0.8, Sum(Sales_All), 0), Department, Category, (ProductID, (NUMERIC))))