Thanks for the reply, on this example the sales and profit are additive. What I'm looking for is one measure forming part of the other, without having to reshape the data. So I would want the graph to look like the attached, where the total is sales and profit forms part of those sales
Mark, it doesn't matter.
You calculate the parts and build using the same mechanism.