4 Replies Latest reply on Jan 30, 2018 12:03 PM by Karolina Skvortsova

    LOD: how to exclude filter in the formula?

    Karolina Skvortsova

      I have several indicators in the dashboard and relative date filter: Created_date "Previous Week".

      this works for all indicators except one. For one indicator I need to calculate the whole amount from the beginning of the quarter till today (QTD)

       

       

      Now I've already have such formula (because of complicated data structure):

      that returns Sales Revenue for each Sales Rep for previous week

       

      How can I modify this formula to exclude filter that on the right side and applied to the whole dash: Created_date: "Previous Week" ?

       

      Thank you!