extrobe
2/22/2017 - 1:04 PM

[SSRS] Format Chart Labels as %

Format Chart Labels as %

=Sum(Fields!Query_Value.Value, "Chart1_SeriesGroup") & " ("  
    &  Sum(Fields!Query_Value.Value, "Chart1_SeriesGroup")  * 100 /Sum(Fields!Query_Value.Value, "DataSet1") 
    & "%)"
	
=Sum(Fields!DATA.Value, "Chart1_SeriesGroup1") & "(" & Format(Sum(Fields!DATA.Value, "Chart1_SeriesGroup1") * 100 /Sum(Fields!DATA.Value, "DataSet1"),"#0.00") & "%)"
	
=FORMAT(Sum(Fields!Query_Value.Value, "Chart1_SeriesGroup")/1000,"£#,##0k") & " ("  
    &  FORMAT(Sum(Fields!Query_Value.Value, "Chart1_SeriesGroup")  * 100 /Sum(Fields!Query_Value.Value, "DataSet1") , "#0.0")
    & "%)"