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)
| Sales | Sex | Year | Country | … 20 |
| 100 | 1 | 2016 | USA |
| 200 | 2 | 2016 | China |
| 300 | 1 | 2016 | Russian |
| 100 | 2 | 2015 | USA |
| 200 | 1 | 2015 | China |
| 300 | 1 | 2015 | Russian |
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;
