Percent Label

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tg112001 - 25 Aug 2008 18:53 GMT

Hi, I'm new to SSRS 2005 and need help with a percent label for a 100%
stacked bar. The examples in this forum don't seem to work for what I'm
trying to do.

I have the following:

Category Field = Sales Region
Series Field = Tier (values are 1, 2, 3 or 4)
Data Field = Total Orders

I need to have the chart labels look like this:

(Tier 1) Tier 2) (Tier 3) Tier 4)
Region A 13% 35% 22% 30%
Region B 15% 22% 8% 55%
Region C 10% 55% 21% 14%

The chart layout is fine but I can't get percentage values to show correctly.
I'd appreciate any help!

Thank you,

Tom

Reply to this Message

tg112001 - 26 Aug 2008 01:57 GMT

I figured it out.
I used this Point Label expression:

=sum(Fields!TOTAL_ORDERS.Value) /
sum(Fields!TOTAL_ORDERS.Value, "chart1_CategoryGroup1")

>Hi, I'm new to SSRS 2005 and need help with a percent label for a 100%
>stacked bar. The examples in this forum don't seem to work for what I'm
[quoted text clipped - 19 lines]
>
>Tom

Reply to this Message

Mónica - 29 Aug 2008 11:19 GMT

Hello tg112001

You can also use format parameters. I mean, in point labels, you have a
field called format where you can write:

p0 -> To show data as percentage with 0 decimals
p1 -> To show data as percentage with 1 decimal
p2 -> To show data as percentage with 2 decimals

In the same line you have also
n0, n1, n2, etc. -> To show number formats (thousands separators and number
of decimals)
c0, c1, c2, etc. -> To show currency values.

Hope this helps,
Mónica

>I figured it out.
> I used this Point Label expression:
[quoted text clipped - 26 lines]
>>
>>Tom

Reply to this Message