at the moment I don't understand how to set expression for calculating index % of margin in linear table graph.
In particolar my goal is calculate the distributions % of variation. Enclosed you can find out an example of my goal.
Note: I'm using a bookmark as based selection before calculate sales and what-if.
Any advice or comment is very appreciated.
thank you very much
I asked and you described the index margin = margin / total margin. In your sample data your margin is 2€ in all rows, then you will obtain the same index margin. In the excel screenshot you posted before the margin (€) were different, and you got different index margins as well.