7 Replies Latest reply on May 17, 2017 11:50 AM by Karolina Skvortsova

    How can I calculate % of total using filters?

    Karolina Skvortsova

      Problem: when I choose the filter, I can't see the real % of total. Instead of that I see 100%.

      I tried to use the following formula COUNT([Task Id]) / SUM({EXCLUDE  [Days] : COUNTD([Task Id])}),

      but it couldn't helped me(

       

      Please find below some screens that explain my problem

       

      1.png

       

      2.png