I have a product dimension table whose level is category-brand-product id. I have a fact table at lowest level product id and measure sales amt which can have positive and negative values.
I need distinct count of brands for a particular category whose sales is greater than 0.
fact table data: product table
productid salesamt category brand productid
c1 b1 1
2 100 &nb
View Complete Post