Forum Discussion
Win Rate
Hi there! I have a table with the 'Sales Information', includes the follwing columns: [Deal Status] -> Active, Signed, Abondend, Booked, Lost. [Deal value] -> Numeric Data. I want to add a new...
Great! it looks better now.
But I missed to mention that every deal has a specific date, and I need the data to be appered on the report by quarter!
The following example is exsactly what I want to show in my report:
| Q1 | Q2 | Q3 | Q4 | |
| Booked | 10 | 12 | 11 | 14 |
| Signed | 1 | 2 | 3 | 4 |
| Lost | 14 | 15 | 16 | 18 |
| Abounded | 1 | 2 | 3 | 4 |
| Win Rate | 42% | 44% | 41% | 44% |
It is like a summary for the current sales situation and alongside the win rate, all in one matrix.
*Please note that my table already includes a column called [Date by Quater]
Thanks a lot for your helping.
Hadill , Create those as measure and show on row like Booked, lost and Win % etc
Or use winrate in grand total using isinscope