COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: SynexusStuart on 24 Jun 2015 10:40:06 AM

Title: show different value on chart
Post by: SynexusStuart on 24 Jun 2015 10:40:06 AM
Hi, I have a graph which is a 100% stacked column chart. It shows, for a certain period, how we are performing vs target.

I like this view because even if a certain product is only selling very few items we can still see this in comparison to it's monthly sales target as a percentage instead of absolute values (which may be difficult to visualise next to high volume sales products...)

However, when looking at the variance, we would like to display the absolute value.

So, Product A has a target sales of 250 and at this point in the month we have sold 100. chart shows 40% (which is correct). We also want to display "100" = sales (or "150" variance) on the chart.

Is this possible? I do not want to show this as a tooltip.

Stu