I have a fact table which is at lowest level(ex product) . i have a product dimension whose level is Category,brand,product.
I need a distinct count of Brands categorywise for a particular quarter and a country whose sales is greater than 100. The fact table is at quarter,country,product level
result set required : quarter,country,category,count(brands)
is there any way to write a mdx for this req??
View Complete Post