Skip to Content
0
Former Member
Oct 12, 2006 at 06:17 PM

Understanding Requirement

19 Views

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