I have a chart which has to plot on Numbers. Sales for each Month stacked on region.
Now I want to see the percentage on the bars. instead of numbers.
Any Clue Please help.
Hi,
Any Idea if this requirement is doable in cognos?
Attaching a snapshot this time for the reference.
have you tried formatting as percentage?
If I change the data format, the numbers get converted to %. like if my value was 1000, that gets converted to % (100000)
then create a new data item with the calculation measure/100 and use that one in your chart as text source and format it as percent. I'm not in front of report studio now but that's how i would try
I get an error when I try to do the same :(
can not have another measure as an attribute: groupBody="% Value".
Isn't this just a case of switching from a Stacked Bar chart to a 100% Stacked Bar chart? Or am I missing something (which is quite normal for me!) :)
Cheers!
MF.
We do not want 100% stacked Bar cahrt. :(
Attaching the snap shot again