1 Reply Latest reply: Apr 19, 2017 7:23 AM by Robin Hausdörfer RSS

    Set Analysis revenue smaller than XYZ date, which still reacts to a selection

    Christian Schmitz

      Hello,

       

      I am trying to show all revenue, which was before or in 201702.

       

      In my use case, there is in 201701: 10$, 201702: 20$ and 201703: 50$.

       

      sum({$<Validity={'Longtime'},kickIN={"<=201702"}>}revenue)

       

      Now my table shows me 30$  revenue (which is correct for 201701+201702).

      But I would like to be able to select kickIN =201701 in the list box, and the graph should show me the subtotal of 201701 (because it is still between my set analysis border).

       

      Unfortunately it is fixed and does not show any difference when I select something. Does anybody have an idea for me please?