3 Replies Latest reply on Nov 5, 2016 7:02 AM by Marc MOUSSA

    Actions filters on Fixed LOD

    Pradeep bukka

      Hi Frds,

      I need a help for below requirement

      I am using fixed LOD for exclude "Furniture" from CATEGORY

      I am using below formula

      { FIXED [Category]: if min([Category])='Furniture' then 1 end }

      I am drag n drop into quick filter and I am excluding 'null' to exclude 'Furniture' from Category.

      Here my question starts

      IN attached screen shot u can find sheet1 and sheet3. Here I am selecting Sheet1 and deselecting sheet1 the records are in the fixed calculation is unselecting 'null' values .Please find attachement