Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Actually my problem is i have .qvd file data. data the used to generate the pivot table like this
month | lost | nodecision | won | grandtotal |
jan | 40 | 30 | 3 | 73 |
feb | 45 | 35 | 4 | 84 |
mar | 65 | 45 | 5 | 115 |
grandtotal | 150 | 110 | 12 | 272 |
but i need this type
month | lost | nodecision | won | grandtotal | Rate%=won/Grandtota |
jan | 40 | 30 | 3 | 73 | won/Grandtotal(3/73) |
feb | 45 | 35 | 4 | 84 | won/Grandtotal(4/84) |
mar | 65 | 45 | 5 | 115 | won/Grandtotal |
grandtotal | 150 | 110 | 12 | 272 | won/Grandtotal |
my using the this expression count({<status={'won'}>}[month])/count(status)
it will generate like this but i need only rate% column after the grand total only
month | lost | nodecision | won | grandtotal | Rate% | |||
grandtotal | Rate% | grandtotal | Rate% | grandtotal | Rate% | |||
jan | 40 | 30 | 3 | 73 | ||||
feb | 45 | 35 | 4 | 84 | ||||
mar | 65 | 45 | 5 | 115 | ||||
grandtotal | 150 | 110 | 12 | 272 |
any one plz help me urgent......
See the file and image
sorry I need only the rate%=won/grandtotal only after the grand total column.
please write the script in the discussion form only plz......
Hi,
Create new expression
Rate % = Sum(won) / (Sum(won)+Sum(lost)+sum(nodecision))
Now in Number tab select Fixed to 1 or 2 (depends on your requirement) and select Show in % option.
Hope this helps you.
Regards,
Jagan.
how to calculate won, lost, no decision all are the status column data.
Here you have the image
Hi,
Attach some sample data and your expected output, without proper info it is difficult to understand and give solution. If you want to get the count of won, lost, no decision then use count
Won - Count(won)
lost - Count(lost)
NoDecision - Count(Nodecision)
Rate % = Count(won) / (Count(won)+Count(lost)+Count(nodecision))
Hope this helps you.
Regards,
Jagan.