Skip to Content
0
Former Member
Jul 03, 2009 at 08:20 PM

Calculate no. of customers between two dates

28 Views

Hi SAP Techies,

I have a reporting requirement wherein i need to calculate no. of customers in a product category @ the start of period , no. of customers @ the end of period and no. of customers added and lost between the period.The period will be user input period @ the selection variables.

I am getting start date and end date of customer for that product category from the source system.

I have calculated no of customers @ the start and end of period, by comparing with the customers' starting and ending date for the product category but not able to calculate the no.of customers added and deleted between the period.

For eg: Suppose user wants to see his customers list between 01.01.2008 to 30.01.2008 for a product A

I have no. of customers lets say 100 @ the start of perod and 50 @ the end of that period. I am not able to get how many customers added and lost between the period, coz if substract 50 from 100 , then it gives info that 50 customers have been lost from product category , whereas it might be possible that 75 customers might have left and 25 new customers must have taken the product A

Please tell how to calculate them separately in two columns in query.Am in hurry for a solution as i have my deadlines nearby

Thanks !!

Kevin

Edited by: Kevin.K on Jul 3, 2009 10:22 PM