display only the highest value with respect to the dimension
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].