1 Reply Latest reply on Jan 26, 2017 2:17 AM by Wim Kegels

    Avoid showing NULL in a filter

    dipti.patel.2

      So i have a End of month report where i have a year, month as filters. But the union data set I am projecting few measures are at the month grain level and there is this one measure Allocation that is not at month grain but its only at year level.

      So in my month filter I am getting a null value. How can I say that irrespective of any month choosen I always want to show the Allocation measure value for a year tht is selected. So if I made sense its like saying do not apply the month filter filter for that measure.

       

      Is this possible any idea around it?

       

      Thank you