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

    sum expression without effect of filters



      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