3 Replies Latest reply: Jan 20, 2016 10:26 AM by Srikanth P

# sum total sales

Hi

I created a straight table  with  3 dimensions (Worker Name ,ID , WRH ) in order to calculate the employee evaluation  bonus

the evaluation bonus = (monthly branch sales)*(manger's employee evaluation - percentage)

as follows :

 worker name ID WRH SALES mangers evaluation BRANCH _TOTAL _SALES BONUS A 1 25 1000 30% 1000 300 B 2 32 2000 10% 5000 500 C 3 32 3000 30% 5000 1500 D 4 57 500 15% 1500 225 E 5 57 1000 85% 1500 1275

I have an issue with the sum expression of  the monthly branch sales ,

i am not sure what to use...

as the  example table above :

i would like the sum branch sales  field to consist all  the sales of the employees from the same branch ,

 C 3 32 3000 30% 5000 1500

5000=3000(sales -B)+2000( sales-C)

can someone assist ?

• ###### Re: sum total sales

Try the TOTAL qualifier in the Sum() function:

=Sum(TOTAL<WRH> SALES)

• ###### Re: sum total sales

it worked.

many thanks

• ###### Re: sum total sales

TOTAL Qualifier ignores the Dimension values in the chart object.

Try Sum( TOTAL <WRH> SALES).

Please mark the question as Correct answer so that will help to others.