If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Chart Axis Labels

Started by cognostechie, 28 Dec 2015 05:12:03 PM

Previous topic - Next topic

cognostechie

I have a Bar Chart to show Year-Over-Year comparison of Net Sales. It is supposed to show what percentage of Net Sales came from which Product during each year. In the attachment, the first bar in Dark Green shows 26% which means that the sales of product in Green for the 'Current Year' (2015) was 26% of the total sales for 2015. This is correct. 'Current Year' and 'Last Year' are the names of Data Items which have a calculated expression to determine percentage of Net Sales for 2014 and 2015. Expression is shown in the attachment. The source is a Cube.

Problem is how to display 2014 and 2015 as the labels instead of 'Current Year' and 'Last Year' . I have tried changing the 'Source Type' property to Data Item Value, Report Expression but none of them show the values. Report Expression does not let me put the MDX, it accepts only relational functions. However, I am able to create a Data Item using MDX and use that in the chart (also shown in the attachment).

My purpose is to display the values of the years, not the name of the Data Item.

Any ideas?

Thanks in advance !