COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: krishdw85 on 10 Sep 2015 08:55:47 AM

Title: Pie chart how to hide extra comma
Post by: krishdw85 on 10 Sep 2015 08:55:47 AM
Hi All,

In the attached chart i just want to see CMB-LLC 33%, not sure why it is displaying extra 33 and comma in between. For pie chart i used only one measure & one dimension. I am running in excel version and i am using 10.1 . How to hide those commas extra 33.
Appreciate if you could help me here. Thanks in adv.
Title: Re: Pie chart how to hide extra comma
Post by: bdbits on 10 Sep 2015 03:59:33 PM
If you run to HTML do you see the same? Then it is probably in your data that way.

If it only shows exported to Excel, you would need to look at where Excel is getting the labels.
Title: Re: Pie chart how to hide extra comma
Post by: krishdw85 on 11 Sep 2015 12:28:46 AM
i dont see comma and extra numbering in html & pdf...it is cmg only in excel output....i dont think cognos has control over excel version...
Title: Re: Pie chart how to hide extra comma
Post by: krishdw85 on 15 Sep 2015 05:21:13 AM
Guys any update... getting issue in excel report , but not in pdf
Title: Re: Pie chart how to hide extra comma
Post by: BigChris on 15 Sep 2015 05:36:32 AM
It's excel rather than Report Studio that's giving you the problem
Title: Re: Pie chart how to hide extra comma
Post by: krishdw85 on 15 Sep 2015 05:50:50 AM
Its Excel giving the issue, in PDF report i dont see those extra comma's.
Title: Re: Pie chart how to hide extra comma
Post by: krishdw85 on 16 Sep 2015 12:46:57 AM
Cognos dnt have control on Excel default formats. We have to manaully edit the excel sheet.
PFA. If any inputs appreciate.