sql server - Incorrect Total Value in SSRS compared with SSAS when Sum Total used -

i have ssas cube works perfectly. trying use build set of ssrs reports running trouble differences between way things interpreted in ssas v ssrs.

i have basic calculated field within ssas cube calculates total number of representatives.

sum([rep].[repname].[all], [measures].[noreps])

in ssas when manipulate customer, territory etc works fine total 'accurate'. being accurate, if list displayed customer , each customer has 5 reps

in ssas

customers | rep | sales | total sales | % of total sales

customer 1 | jane | $500 | $2,000 | 25%

customer 1 | mary | $1,250 | $2,000 | 62.5%

customer 1 | bill | $250 | $2,000 | 12.5%

total | total | $2,000 | $2,000 | 100%

in ssrs

customers | rep | sales | total sales | % of total sales

customer 1 | jane | $500 | $2,000 | 25%

customer 1 | mary | $1,250 | $2,000 | 62.5%

customer 1 | bill | $250 | $2,000 | 12.5%

total | total | $2,000 | $6,000 | 33%

what doing wrong cannot replicate table in ssrs? appreciated?

you must remove sum() in totals on table (or other control). e.g. sum(fields!yourfields.value) fields!yourfields.value

UV code