9 Replies Latest reply on Apr 27, 2018 10:55 AM by Jim Dehner

    How to display 1 measure with muliple dimensions with logic

    David Matthews

      Hello

       

      Looking for assistance for the best way to do this. I've attached a sample XLS file with dummy data. What I am looking to do is show the product count per product by year for each product only if the product value is "purple". So if the product value is purple then use the product count, if not then don't. Actually next step might be by all values. Not sure how to get started with this. Any suggestions would be appreciated.

       

      Thanks