I am trying to add some kind of calculated item (Excel equivalent) into a tablix I have created from a dataset.
e.g.
Type Today Month Annual
Sales 1,000 15,000 35,000
GP 200 1,500 5,000
I want to add a row below that will calculate the margin % and also be dynamic so when the figures change, so will the Margin %
e.g.
Type Today Month Annual
Sales 1,000 15,000 35,000
GP 200 1,500 5,000
Margin % 20% 10% 14.3%