2 Replies Latest reply on Nov 4, 2016 8:31 AM by Norbert Maijoor

    How do I combine three measures into one?

    Samuel Gee


      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?


      Thank you.