4 Replies Latest reply on Nov 20, 2018 11:55 AM by luxia whiting

    Level of Detail Expression help!

    luxia whiting

      Hi, the LOD expression doesn't work as I expect.

       

      The source data looks like below.

      CategoryDate Org
      NULL6/1/2018XYZ
      NULL7/1/2018XYZ
      NULL8/1/2018XYZ
      NULL9/1/2018XYZ
      A6/15/2018XYZ
      A7/8/2018XYZ
      A8/5/2018XYZ

       

      And I'm trying to create the following table with columns being Month/Year of the Date field and rows being the Org field, along with "Category" field being the filter. Right now, the Month "September 2018" column goes away when I dis-select NULL from the Category filter. So I created another date field using this LOD expression: { FIXED [Org], MONTH[Date],YEAR[Date]: MIN[Date] }, hoping using this new date field as columns would ignore the Category filter. But the same thing happens, Sep 2018 column disappears when Category A is selected.

       

                  June 2018 | July 2018 | August 2018 | September 2018

      XYZ

       

       

      Thanks in advance for your help!