Hi,
I am new to Qlik Sense. I have my data in this format:
| | Region A | Region B |
| | Met TAT | Exceeded TAT | Met TAT | Exceeded TAT |
| Company A | 0 | 0 | 34 | 5 |
| Company B | 7 | 0 | 53 | 5 |
| Company C | 18 | 1 | 15 | 1 |
| Company D | 1 | 0 | 1 | 0 |
| Company E | 108 | 4 | 669 | 84 |
| Total | 134 | 5 | 772 | 95 |
I want to show this data so that against company B in Region A, I have a % such as: 7/(134+5 - which is Region A total)
I do not know if I am clear in explaining my requirement, so I am attaching an excel with the calculation.
Please help me achieve this in Qlik sense
Regards,
Ashwini
