I wonder if someone could help.
I have a query which returns the following:
Vendor Revenue
------ -------
Vendor1 100
Vendor2 25
Vendor3 75
I then have a pie chart for this data and currently, the label for each is set to:
=format(Fields!Revenue.Value,"#0") & " - " & Fields!MasterGroup.Value
Instead of the Revenue value, how do I get this to show the percentage of the total Revenue?
Thanks in advance
Adam
Adam Blackwell
Business Intelligence Analyst
I have a query which returns the following:
Vendor Revenue
------ -------
Vendor1 100
Vendor2 25
Vendor3 75
I then have a pie chart for this data and currently, the label for each is set to:
=format(Fields!Revenue.Value,"#0") & " - " & Fields!MasterGroup.Value
Instead of the Revenue value, how do I get this to show the percentage of the total Revenue?
Thanks in advance
Adam
Adam Blackwell
Business Intelligence Analyst