Bar chart: showing percentages AND totals

[#1]

Hello all,

I believe this is a problem which can be solve relatively easily, although I have not be able to do so.

Please have a look at my example picture.

This is what I am looking for:

- The y-ax should be displayed as it is now

- The total per bar should be a percentage of the sum of all bars.

- Hoovering over a bar: the label should give the value, as is displayed on top of the bar as in the example.

- the legend should remain the same, since these represent several groups.

I would really appreciate any help

Thank you

[Anonymous]

Hi

Please see the example, I used a combo chart to display this and using set analysis and TOTAL for getting the relative number that sticks if you select a value of the dimension.

[#3]

Kullenberg, thank you for your reply.

There is one additional question i would like to ask, since there seems to be a difference between your file any my working file (which i did not know it matters). Anyway, in my case the 'F1' as shown in your file, is not a dimension, but an expression. This also means that, for each bar (or value in your example, like 1,2,3,4,5, etc), I have another expression. For this reason it seems that I am not able to use your set analysis as it is.

Please have a look at the file attached.

Hopefully you can help me to obtain the preferred display.

Thank you