Forum Discussion
Win Rate
Hadill , Try a measure like
Divide( Calculate(Sum(Table[Deal Amount] ), Filter(Table, Table[Status] ="Booked")) ,Calculate(Sum(Table[Deal Amount] ), Filter(Table, Table[Status] in{"Booked","Lost"} )))
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