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


Comments

Popular posts from this blog

asp.net mvc - SSO between MVCForum and Umbraco7 -

Python Tkinter keyboard using bind -

ubuntu - Selenium Node Not Connecting to Hub, Not Opening Port -