2 Replies Latest reply on Jul 11, 2018 9:31 PM by Peter Fakan

    Filtering with % of Total Running Sum of Spend

    Federica Stoppa

      hello

      I have build a pareto chart of spend vs suppliers.

      I would like to use the % of Total Running Sum of Spend to filter the pareto chart as well as the count of suppliers associated with that.

      For eample if I want to see % of running sum of spend between 38.15 and 80%, I would like to see that it is 3 suppliers that are contribution to that (not the total 16 that is currently showing in the dashboard). Normally I will be able to apply the filter top the various sheets I want, but this filter is different than the other.

       

      How can I make that happen?

       

      thanks for any help

       

      Federica