3 Replies Latest reply on Jan 18, 2019 3:10 AM by Jim Dehner

    Filtering dimentions by RUNNING SUM value

    Kohei Kamada

      Left chart is sales of Sub-Category sorted in descending order.

      Right is accumulated % of each Sub-category, calculated like "RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([sales]))".


      <What I'd like to do>

      I'd like to filter items to above 80% of "RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([sales]))".

      When I set sub-category to filter space, I couldn't select running sum value for filtering item.


      If anyone knows how to do, I'd like you to let me know.

       

      Best,

       

       

       

       

      20190117.PNG