Hi,
Does anyone know how to create a '100% stacked column' chart in a way, that tool compares the % not to the total, but to the reported groups? I.e.: sum(Product "X")=100%
| Product "X" | Product "Y" | Product "Z" | Grand Total |
Approved | 1,427,075 | 267,717 | 1,189,907 | 2,884,699 |
Rejected | 847,693 | 765,022 | 817,593 | 2,430,308 |
And is it possible in any way to have both, the values and the % visible in the same chart? Or at least add the values into a % bar chart? Many thanks for your help!