5 Replies Latest reply on Feb 18, 2016 9:18 PM by sudhakar reddy

    ratheSubtracting 2 dimensions from a Sales Measure

    Sunil Rai

      Hi all,

       

      I have Sales. And I wish to create a calculated field that allows me to subtract the sales (based on 2 dimensions - shoes and socks). Such that I can get a calculated field that is the difference.

       

      Any idea how?

       

      Or rather to be more explicit. I have a string dimension (Holiday2015 and Holiday 2016). I have created a chart showing them one below another. I need a third chart below to show the difference between both).

       

       

      Holiday15

      Holiday16

      Difference

                      Shoes   Socks  Shirts

       

      I need the difference below. Holiday 15 and Holiday16 are one dimension called "Season"

       

      Cheers,

      Sunil