Hi, Where two lists are prepared in a hierarchy structure, is it possible to hide the parent's subtotal line in a module? For example, where the two lists of product category and products are prepared (screenshot_1.png), I want to get the results without product category subtotal lines in the module whch calculates sales amount by products. (I want to get the result of screenshot_3.png, NOT screenshot_2.png.) Is it possible in anaplan? Regards, Maki Yasuda
If you right click on the categories in the module (the list itself) you can choose to select the levels that you wish to see. If you unselect your Product_Category_L1 box this will hide the subtotals.
If you still need to see which L1 category each L2 category is in but in the same row (as in your 3rd screenshot) you could add a line item using a formula such as:
and it's available in dashboard too.
Good practice will be
1°) to create saved view if this is a reccuring need and the view has to be published on a dashboard
2°) to train end user to use this very usefull feature.
Hi Kirsty and Michel,
Thank you for your kind advice.
Especially, it is very helpful for me that I can select the levels to be shown in the right click menu.
BTW, is it possible to locate L1 category on the left side of L2 category (on the gray-colored area, not as a line item) in the same row?
If possible, that's more helpful for me.
Thanks and regards,