how to show percentage data in age pyramid bar chart?

[marjan_it]

Hi

H make a Age Pyramid bar chart like the image. it works good when I show data as integer but when I want to show data in Percent

the left Piece of bar chart shows negative percent data.

what can I do to show all data in positive percent?!

[swuehl]

Try using the dual() function, like

=Dual( Num( Count(FIELD) / Count(TOTAL FIELD),'#.00%','.',','), -Count(Field) )

for the left side expression and

=Dual( Num( Count(FIELD) / Count(TOTAL FIELD),'#.00%','.',','), Count(Field) )

for the right side expression.

Disable the 'relative' option.

[marjan_it]

I do this but it doesnt work. in this case shoe data in number not percent and show in negative.

[swuehl]

Could you upload a small sample QVW?

[marjan_it]

Yes of course. this is my sample.

[swuehl · Accepted solution]

Ok, I would need to check why my suggestion did not work.

But you can make your approach work by changing the format code in number tab to

#,##0%;#,##0%;

i,e, specifiying a format for the negative values without a minus sign.

[marjan_it]

Thanks so much. this is work goood