Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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