Hide row Total in Interactive Planning when drilldowned
please, could you share your experience and tell, how I can hide the row TOTAL in the Interactive Planning displayed when I make a dilldown by any type of object (locations, products, resources... ). There is always a row Total, summarizing the amount of pieces in the current key-figure.
Thank you in advance,
Jean Vroemen replied
Hi Kirill Nepomnyashchiy.
I don't understand your statement that it is not posible to perform a drill down if there is only one material.
We want to drill down first material and then secondly on plant. Our pivot shows then all materials and per material all plants. Some materials have multiple plants, others do only have one plant. In that case, those materials will have a total and details for that specific plant.
We are now looking at macro's that run on a specific level (via properties you can set the level, eg. details, all planning objects, certain levels (0 agg level, 1, 2 ,3 ...). By using a macro for all levels that switches off all rows (ROW_VISIBLE ( 0 )), and another one that runs on details level, to switch on the rows (ROW_VISIBLE ( 1 )) we are trying to suppress the totals.
Do you see any disadvantages of this solution?
thanks in advance