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|
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!