Totals selection added - not returning correct total %
Helllo - I have added a pivot table that has data columns which include Budgets, Obligations and Obligation percentage (Measures) and Fund Title and Fund year (Dimensions) then selected the selected the totals button (Under Fund Year) to return totals for all columns. Which worked great, however, the total column under Obligation Percentage is returning a value of 500%. The total percentage of all obligations percentages added together? I just want it to return the percentage of the total value of Budgets and Obligations. I.e. I would like = $5000 (Obligations) / 10000 (budget) = 50% Not 400% . Can someone please assis?
Likely going to need to attach the QVW file or provide further details and sample data etc. in order to get responses on this one. Generally folks like to check the data model as well as the object and its expressions etc. when trying to work these types of posts, so attaching QVW will significantly improve odds of getting responses more quickly.
About the only thing I can point to currently is Product Help in order for you to check the documented functionality of things to be sure you have not missed something there or have misunderstood the functionality you are trying to use.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.