3 Replies Latest reply on Oct 7, 2016 4:40 AM by Norbert Maijoor

    Issue with calculation and filter

    Sabine Honer

      Hi All,


      I hope you are doing fine.

      I iahve created three calcultaed fields:

      1: will return only data for 2015 for months 1-6

      2. will return only data for 2016 for months 1-6

      3. is (field2/field1)-1


      Issue is that if I filter data only for year 2016, no data will be visible for 2015.

      How do I need to adjust my fields that it will show data also for 2015?


      And as another complication: Data can be shown for Level 3 only, or for Level 1 only or for all three levels...




      I am thankful for any hint.


      Best regards