Need some Modelling tips. I am getting data in the cube as below:Region Product Sale USA ABC 10 DEF 7 XYZ 40 EUROPE DEF 5 XYZ 6 ASIA ABC 13 DEF 17 XYZ 50
I am required to add a new data in the report with logic :
If for perticular 'Region' all product sale is =< 10 then 'Expand' else 'Close'. That is for the perticular region if any of the product have sale below 10 then 'Close' for entier region. Please suggest how can I achive this with transformation (not involving any routine). I understand I cannot handle this at query level as I cannot update the word 'Expand' or 'Close' using query designer.