Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 21 Dec 2016 04:23:45 AM

Title: how to display chart value(Y-axis) in reverse order using DMR model
Post by: inu on 21 Dec 2016 04:23:45 AM
Hi Team,

I have a bubble chart, which is displaying values from 0-n.
But i want to display from max to min n-0 .
Please suggest , how to do so....


Regards,
Inam
Title: Re: how to display chart value(Y-axis) in reverse order using DMR model
Post by: Michael75 on 21 Dec 2016 10:00:04 AM
Multiply your values by -1, and format them so that the sign isn't displayed.
Title: Re: how to display chart value(Y-axis) in reverse order using DMR model
Post by: inu on 22 Dec 2016 06:12:09 AM
Quote from: Michael75 on 21 Dec 2016 10:00:04 AM
Multiply your values by -1, and format them so that the sign isn't displayed.

Thanx,, it helped.. but unable to remove the minus sign..I saw in data format for number category,, no option for removing - sign...


Regards,
Inam
Text only | Text with Images