7 Replies Latest reply: Nov 4, 2012 8:16 AM by Mathias Mühlfelder RSS

    sum expression without effect of filters

    Mathias Mühlfelder

      Folks,

       

      I have daily data in my tables. I am trying to build an expression to get the sum OUTBOUND DAILY of the last 30 days:

       

      sum({<Date_Daily = {">=$(=(Today()-30)) <$(=Today())"}>} [OUTBOUND DAILY])

       

      The formular works fine as long as i don't filter to specific dates for other diagrams. As soon as i filter the dates, i just got the volume of the 30 days within the selected days. I would like to get always back the full 30 days. But other selections (on other fields of the table) shall apply to the result.

       

      Thanks for any hint,

       

      Regards Mathias