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).






                      Shoes   Socks  Shirts


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