Unfortunately, I am unable to open your attachement. It says 'Failed to open document'. Could you check your attached document, please?
It would be useful if you could state your calculated dimension in your post.
Maybe you could replace the calculated dimension with set analysis in your expressions. Probably not, since ABC classification seems to create new dimension values.
Would it be feasible to create this field in your script or does it need to be selection sensitive?
I'll try to repost the document to see if you can open it.
About the other options you proposed-
- Creating this field in the script is not an option, because we load data from the sales table in 3 different databases, and the aggregation is done using Item Group classification, not Item Code.
- Maybe I could replace the calculated dimension with set analysis, but if possible, I have no clue about how it could be done.
The aggregated dimension is as follows:
=Aggr( IF(Sum(SALES.GrossProfit)/Sum(SALES.LineTotal)>=0.6, 'A', IF(Sum(SALES.GrossProfit)/Sum(SALES.LineTotal)>=0.5, 'B', IF(Sum(SALES.GrossProfit)/Sum(SALES.LineTotal)>=0.4, 'C', IF(Sum(SALES.GrossProfit)/Sum(SALES.LineTotal)>=0.3, 'D', 'E') ) ) ), ItemGrp, /*This is the dimension I need to aggregate by*/ Year /* This is the dimension that shows also in the pivot table and the one that needs the partial totals*/ )
ABC_Classification.qvw 314.8 K