Hi, I have a report based in this data:
Status Year Month Qty
Win 2005 1 5
Win 2005 2 2
Win 2005 6 3
Win 2006 1 5
...
Win 2006 12 4
Lost 2005 1 22
...
Lost 2006 12 33
The report matrix has this structure:
+2005 +2006
Win 10 15
Lost 100 145
Total 110 160
I'm need calculate the percenter of Win about the Total
( Win / Total * 100) for each Month and for the Year (what isn´t the sum of the monts´percenters)
This will be part of the grouping mechanism for the colapses/expanded function.
How can I do it???
Best Regards.
Status Year Month Qty
Win 2005 1 5
Win 2005 2 2
Win 2005 6 3
Win 2006 1 5
...
Win 2006 12 4
Lost 2005 1 22
...
Lost 2006 12 33
The report matrix has this structure:
+2005 +2006
Win 10 15
Lost 100 145
Total 110 160
I'm need calculate the percenter of Win about the Total
( Win / Total * 100) for each Month and for the Year (what isn´t the sum of the monts´percenters)
This will be part of the grouping mechanism for the colapses/expanded function.
How can I do it???
Best Regards.