5 Replies Latest reply on Nov 27, 2016 4:06 PM by Nachiket Dekhane

    How to filter what shows on a chart without filtering the underlying data

    Charlotte Moon

      I am trying to show product penetration in a graph (transactions of product/total transactions)

       

      I can't fit all my products on a graph so I want to do one graph for Cold Drinks, one Hot Drinks, one for burgers, One for Other and on each chart show penetration by product.

       

      If I filter on the category my graph only shows me penetration of my products within transactions in that category but I want to still see penetration of the product against the whole transactions universe

       

      I think maybe I need to create a parameter for this so I created a Category Parameter by right cliking on the dimension and then create, parameter but I'm not sure what to do with it or whether this is the correct approach??

       

      Hopefully someone can help me before I give up and export to Excel!