5 Replies Latest reply on Aug 24, 2018 12:48 PM by Deepak Rai

    Fixed LOD calculation

    naga.kodali.1

      Hi All,

       

      I am looking for guidance on the  Fixed LOD calculation.

      I am trying to calculate the top customers in the company by quantity for the last 6 months lets say Jan -June 2018

      There are many other dimensions in my view .But I need to find top customers by quantity for the  product category lets say  Furniture.

      I already have filters placed on product category: Furniture and Months selected from Jan-June.

      Should my fixed calculation read as

      {Fixed [Customer],[Month],Product Category]: Sum(Quantity)}

      (OR )

      {Fixed [Customer]: Sum(Quantity)}

       

      Kindly advise !


      Thanks,

      Swapna