This content has been marked as final. Show 2 replies
I have four measures, Total sales, X sales, Y sales and Z sales, all in the same data source.
Total sales = X + Y + Z sales.
What I'd like is to be able to have Total sales in the view, splitting out X Y and Z by colour. Or run a table calc where X Y and Z are calculated as a % of TOTAL.
Because they're four separate measures I can't get them to interact in this way.
I'm fairly sure the answer lies in data blending or scaffolding, but I'm not sure of the process. All the resources I can find are about blending different data sources, whereas these are three measures from the same source.
Can anyone help?