1 Reply Latest reply: Oct 5, 2015 10:01 PM by Jonathan Poole RSS

    How can I filter an object using data handling

      Hi,

       

      I have done quite some research on this but not found an adequate answer, yet.

       

      I have a simple sum function for a KPI. On different Sheets, I use the same KPI but want to apply different filter.

      The KPI is simply total revenue generated.

      One one sheet, I want the full sum over all data.

      On another sheet, I want to limit it to last month, only. I realize I can do this with measures, but I want to avoid duplicating a whole load of measures. I rather want to use the same measures and apply the condition in the "Add-Ons" -> "Data handling" -> "Calculation Condition".

      I feel this should be possible, but I have not found a formula yet which filters accordingly.

       

      So far, I have tried the following entries in that field (simplified to fixed month).

      IF(month=8,1,0)

       

      or

       

      month=8

       

      Neither of this works so I am currently out of ideas. Can anyone help?

       

      Michael !