COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: sukanya on 15 Dec 2017 04:35:00 AM

Title: cumulative value of stacks in a bar on top of the bar only
Post by: sukanya on 15 Dec 2017 04:35:00 AM
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,
Title: Re: cumulative value of stacks in a bar on top of the bar only
Post by: sukanya on 15 Dec 2017 10:55:10 AM
Any ideas?
Title: Re: cumulative value of stacks in a bar on top of the bar only
Post by: sukanya on 17 Dec 2017 07:55:29 PM
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,