1 of 1 people found this helpful
Measure values is not a complete measure, it a combination of measure in your case it measure 1 to measure 5. So the quick table calculations will not be present.
To solve this you have to create percent of total for each measure separately first as calculated fields
Measure 1 - 100
Measure 2 - Measure 2/ Measure 1 = 80%
Like way, create calculated field for all five measures. Then use the calculated fields into "Annotations" on top of the bar charts (example chart)
Then format each annotation to remove all lines, arrows and borders and place on top of each bars on your measure values. Now the report will look like having percentage distribution for all measure values.
Hope this should solve your problem. Try it out and respond if it doesnt work for you!
Help is bountiful here, but we need a workbook to play with.
Thanks for your solution it worked. Is there any other way to do this please respond but somehow I got the solution. Thanks again !!