Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I attached the tables i have:
-First how can i get the Percentage in table 3 as 647/ (647+589) and so on.
-Second i need to merge the tables together in order TABLE 1 - TABLE 2 - TABLE 3 so i get the table as follow
Waiting Time | Visit Type |
| Percentage% |
| Percentage% | Visit Type |
| Percentage% |
<30m | Yes | 20 | 13% | 50 | 32% | Yes | 20 | 40% |
No | 30 | 19% | No | 30 | 60% | |||
31-60m | Yes | 10 | 6% | 43 | 27% | Yes | 10 | 23% |
No | 33 | 21% | No | 33 | 77% | |||
1-2h | Yes | 2 | 1% | 47 | 30% | Yes | 2 | 4% |
No | 45 | 28% | No | 45 | 96% | |||
>2h | Yes | 12 | 8% | 18 | 11% | Yes | 12 | 67% |
No | 6 | 4% | No | 6 | 33% |
THANKS A LOT
If you could upload your sample file, will definitely try to help you.
sorry i cannot share the dash as it is confidential data. I guess the data presented to you us enough.
Especially for the formula part