6 Replies Latest reply: Aug 21, 2017 6:11 AM by Divya Anand RSS

    display only the highest value with respect to the dimension

    Divya Anand

      Hi All,

       

      I am trying to create a table and a bar chart where the highest value of sum(value) with respect to each Product is only displayed in the table and a bar chart. Can someone help me in displaying only these top values against the product in a table and a bar chart?

      In the table I would like to have Product, Field, Week and the expression sum(value) [only the top values].

      In the bar chart I am looking for sum(value) against the Product dimension [only the top values].

       

      PFA a sample QVW.