Stacked Bar Chart - FMP12
I would appreciate assistance in creating a Stacked Bar Chart report for my sales data.
The data is pretty standard. I have one field that is called 'Delivery Month' which indicates the date in which the engagement is to be delivered. I have a second field called 'Sales Stage' which indicates how far along the sales funnel the engagement is (i.e. Qualified, Proposal Submitted, Verbal Confirmation, Won, etc.). I have a third field named 'Price' which indicates the expected revenue from that engagement.
With these three fields, I would like to create a stacked bar chart with the x-axis reflecting the months of the year and the y-axis reflecting the stage of sale and total revene for each engagement within each month. So one bar for any given month would reflect the dollar value total for each of the sales stages.
If more details are required, please advise. I thank you in advance for any assistance you're able to provide.