Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have just created a table which looks like below. This table gives me count of items in each bucket for each person...
| bucket | Created By | admin | Madhukar | Naveen | Premansh | premansh | Taufeeq |
| 60-300 | 5 | 553 | 294 | 157 | 14 | 609 | |
| 300-420 | - | 165 | 128 | 72 | 6 | 156 | |
| 0-60 | - | - | 1 | - | - | - | |
| 420-540 | - | - | 1 | - | - | - |
Now want i want is %age contribution of each person in each bucket; i.e. a table which should look like below.
Please let me know how can i create below table in qV
| Bucket Wise % | |||||
| Bucket | Madhukar | Naveen | Premansh | Taufeeq | Total |
| 60-300 | 100% | 99% | 100% | 98% | 99% |
| 300-420 | 0% | 1% | 0% | 2% | 1% |
| 420-540 | 0% | 0% | 0% | 0% | 0% |
| 540-660 | 0% | 0% | 0% | 0% | 0% |
| 660-720 | 0% | 0% | 0% | 0% | 0% |
| 720 & Above | 0% | 0% | 0% | 0% | 0% |
| Total | 100% | 100% | 100% | 100% | 100% |
count(Bucket)/count(TOTAL <"Dimension field"> bucket)
count(Bucket)/count(TOTAL <"Dimension field"> bucket)