As per the requirement, I have to display the value and the percentage in the single bar in the bar chart.
Let me know, Is there any option to implement this requirement.
Thanks in advance,
Pls refer attached a sample application, you have to include the same expression twice in the bar chart then when you click the 2nd expression there will be 'Group' button below the expressions. using that you can group the expressions
for the 2nd expression check the 'Relative' check box and the number format should be Percentage.
hope this meets your requirement
Thanks for the solution, I was looking for the same solution.
Is there any other alternative to implement the same requirement other than dual function.
I want to use this in the set expression.
Please find the .qvw
=dual( Sum([Test Score]) & ' (' & num((Sum([Test Score]))/(Sum(Total [Test Score])),'##.0%') & ')',
Sum([Test Score]) +(sum([Test Score]))/(Sum(Total [Test Score]))/100 )