2 Replies Latest reply: Oct 6, 2016 12:41 PM by Sunny Talwar RSS

    Ignore all dimensions, except for one

    Михаил Сирик

      Pls, help!

       

      Let me have 20 dimensions (Sex, Year, Country ... etc 20 dimensions). I also have a measure of "Sales". All in a single table.

      How do I calculate the amount of expression on the "Sales", ignoring all the dimensions, except for one of the dimensions. For example, the dimension of "Sex" should be considered.

       

      Like that:

      =sum({1<(ignore)Sex>} Sale)

       

      SalesSexYearCountry… 20
      10012016USA
      20022016China
      30012016Russian
      10022015USA
      20012015China
      30012015Russian

       

      Result:

       

      If user choose Sex = 1 then the sum must be equal to 900;

      If user choose Sex = 2 and Year = 2016 then the amount should be equal to 300;

      If user choose Sex = 1 and Year = 2016 and Country = USA then the amount must be equal to 900;