I know this. But I cannot do it because I want to display both the percentages and numbers(without percentage).
I have used qsvariable extension. when I select % from the drop down, the line chart should display the results with %. When I sleect numbers from the drop down line chart should display only numbers
Try the below code:
num((Sum(Survey participants)/Sum(Total Participants) * 100), '#,##0%')
Use only Sum(Survey participants)/Sum(Total Participants) in the expression and on the measure field set the below formatting :
Number formatting --> Number
Formatting--> Simple--> 12%
Hope this helps...