Hi Friends
I have got the following requirement from the client.
B4
Report Name Segmentation Forecast
Purpose / Aim To show current pipeline vs. target/track in terms of Rev/Count
Parameters / Limits Opportunity Line Item Delivery Date should belong to the given Quarter Relevant for Forecast is ticked
Report Logic For each value of 9-Cell Matrix the Report Output will be generated as mentioned in the Sample Output
Count the Total no. of unique Customers for the given Segment of 9-cell Matrix. This will be (A).
Count the Total no. of Customers for each month of the Quarter considering each Line Item of an Opportunity as a single entry. Also perform the summation of Revenue for each of these Opportunity Line Items. These will be (B)
Count the total no. of unique Customers for the given Quarter (The Delivery Date of Opportunity Line Item should fall in the given Quarter). Also perform the summation of Revenue for each of these Opportunity Line Items. This will be (C).
Sample Output Customers Revenue
(A) Total xxxx
(B) Month 1 xxxx xxxx
(B) Month 2 xxxx xxxx
(B) Month 3 xxxx xxxx
(C) QTR Total xxxx xxxx
-
For each value of 9-Cell Matrix the Report Output will be generated as mentioned in the Sample Output
What does the above statement explains.What is 9 Cell matrix
If any has done these type of reports can any one explain me please
thanks for your help
sundaresan