When you say a variety of expressions, what do you mean? Do you have a sample file? Generally if you want a percentage of a whole you can use TOTAL. For example Sum(Volume)/Sum(TOTAL Volume) for the percentage of total volume by sales rep (see attached).
Test.qvw 967.2 K
Thank you very much for your prompt answer. I reviewed your qvw file and it looks great. I can see how you were able to get the percentages. However, I am unable to duplicate your method.
Can you please review my test Excel sheet with 12 rows of data? Basically, I want to compute the sum and percentage of "Number of Claims" for each partner.
I have also attached my test qvw file where I have set my "Dimension" as Partner and have created a pie chart object but with no results.
Thank you again. I greatly appreciate your help.