sum total sales

[tomer1984]

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 ?

[swuehl]

Try the TOTAL qualifier in the Sum() function:

=Sum(TOTAL<WRH> SALES)

[tomer1984]

it worked.

many thanks

[#4 · Accepted solution]

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.