cumulative value of stacks in a bar on top of the bar only

[sukanya]

Hi All,
Is there a way to show cumulative value of stacks on top of a stacked bar without showing individual stack value. kindly let me know.

Regards,

[sukanya]

Any ideas?

[sukanya]

I got this resolved by adding secondary axis and slicing the default measure value by another data item hardcoded as 'All'. This is a line which is superimposed on stackedbar and in its properties Line and Markers set as Markers. This allowed to show cumulative at the top of the bar while stacked bar showed each slice and also stacked bar showing slice value when you hoverover. I selected showvalues for only line (secondar axis) but not for stacked bar. Hope it helps someone looking for similar solution.

Regards,