1 Reply Latest reply on Jul 30, 2016 1:37 AM by Ashish Chaudhari

    Count of customers where days without order is..

    lalitha p

      Hi Everyone,

       

         I have a requirement like this.

       

      I have my customers and Product group. In my report i want to show,

       

      Count (customer,Product Group) where days withoutorder 0 - 91 days

       

      Count (customer,Product Group) where dayswithoutorder > 91 days

       

      How many customers whose has not put their order from past 91 days and how many customers whose has not been put their order from 0-91 days . These 2  i want to show in my report.

      I have days without order field also available in my database.

       

      I am trying somehow like this which is shown as below.

       

      if [Days Since Last Order] >= 0 and [Days Since Last Order] <= 91 then { FIXED [Product Group Display],[Customer Name (Name)] : COUNTD([Customer Name (Name)])  }

      END

       

      if [Days Since Last Order] >91 then { FIXED [Product Group Display],[Customer Name (Name)] : COUNTD([Customer Name (Name)])  }

      END

       

      I have so many filters in my report at the top level which should these 2 fields also. So will it affect anything badly as i have used fixed here.

       

      Can anyone please help me up.,

       

      Regards

      Lalitha K Prabhala