1 Reply Latest reply on Jan 17, 2014 6:34 AM by sira.sasitorn

    Hiding/Showing Measure Values Based on Dimension




      Is it possible to hide a Measure Values based on product type? For example, in the picture below, if the product is "Coffee", I want it to display all the Measure Values. But if it is "Tea", I want to display only Sales, Inventory, and Margin. I know this can be done by separating it into 2 views, but I would like them to be in the same view.


      The problem is, if I right click on Marketing column under "Tea" and click Hide it, it will also hide Marketing column under "Coffee". Is there a way to remove it just for values with Product Type = "Tea"?


      Thanks in advance