Multiple conditions in set analysis for dimension

[sanpor1zd]

Hello,

i'm trying to display a table providing information about shoes based on some conditions. 

i tried using set analysis for my table based on the country, the type of shoes and the price but to no avail. 

for example:

Aggr(Only({<Country= 'South America', TypeOfShoe = 'Sports Shoe', Brand = 'Nike', Price < 130,>} ShoeID), ShoeID)

the results was shown as above. 

Please let me know what went wrong 

thank you so much

[nikitadeshwal · Accepted solution]

Hi,

You can simply use below expression,

sum({<Country= {'India'}, Type = {'Sport'}, Brand = {'Nike'},Price ={ ">500"}>} Price)

I hope this helped you...

Regards,

Nikita Deshwal