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