I have developed piechart in ssrs with multiple datasets. My scenerio is to set Percentage format for values in Piechart. For same dataset the percentage value is showed correctly, but for values fetch from another dataset can't fetch percentage in piechart. For same dataset the value is as following :
=Sum(Fields!myValue.Value)
For value from another datset:
=Sum(Fields!myVal1.Value, "GetMyValue")
I set Lable value as "#PERCENT" in series properties. For different dataset, is there anything need to change? can anypne help me to solve this..
I have added the sample report image here.
Thanks in advance..