13 Replies Latest reply on Aug 4, 2016 10:08 PM by Ashish Chaudhari

    How to use a filter to sort by by category on a stacked chart?

    Patrick Myles

      Hi all - My problem is that I would like to have a filter that can select which category to sort (descending) by.  for example, have a filter (perhaps parameter) that sorts by either technology, office supplies or furniture.  you'll see there is a table calculation in sales which is 'percent of total' (ie to make it into a 100% stacked chart).  Workbook attached. 

      any help appreciated!

      Pat