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

    How do I combine three measures into one?

    Samuel Gee

      Hi,


      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.

       

      Sam