Percentage Charts

[Ann]

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.

[Ann]

Hi,

Any Idea if this requirement is doable in cognos?

Attaching a snapshot this time for the reference.

[adik]

have you tried formatting as percentage?

[Ann]

If I change the data format, the numbers get converted to %. like if my value was 1000, that gets converted to % (100000)

[adik]

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

[Ann]

I get an error when I try to do the same :(


can not have another measure as an attribute: groupBody="% Value".

[MFGF]

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.

[Ann]

We do not want 100% stacked  Bar cahrt. :(
Attaching the snap shot again