1 Reply Latest reply on Aug 24, 2018 1:26 AM by ArseneXie

    LOD ignore filter

    alexandra price

      Hi folks,

       

      I am trying to ignore a time filter , for example,

                 - I have a table with 2017 and 2018 data and

                 - 2017 calculated fields which ignore the year selection

                 - Using LOD rather than parameter

       

      This is original page , where the sum of 2017 is 62,835 and 2018 24,318

       

      , when i select 2018,

       

       

       

      then when i click year filter to only 2018, it only show 2018 data as below

       

      Where my expected result is ,

       

      Thanks guys

        • 1. Re: LOD ignore filter
          ArseneXie

          Hi Alexandra,

           

          Is this what you expected?

          Always show 2017 data as a reference?

           

          I make a little change for the 2017 CF:

           

          {

          sum(

          if Year=2017 then Value else 0 end

          )

          }

           

          Then it might be what you want.

           

           

          and

          {

          sum(

          if Year=2017 then Value else 0 end

          )

          }

           

          is equal to

          { FIXED :

          sum(

          if Year=2017 then Value else 0 end

          )

          }

           

           

          Arsene