Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
Try the TOTAL qualifier in the Sum() function:
=Sum(TOTAL<WRH> SALES)
it worked.
many thanks
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.