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...

       

       

      issue.jpg

      I am thankful for any hint.

       

      Best regards

      Sabine