Forum Discussion
Sum subtotal value
Hi all,
Below table shows subject wise values which is calculated by a formulae and is correct but if I try to check it at employee or manager level, it always shows calculated number / not summation of these values (subtotal value). I need a measure to sum all values at any level.
| Manager 1 | Employee 1 | Subject 1 | 32 |
| Manager 1 | Employee 1 | Subject 2 | 48 |
| Manager 1 | Employee 2 | Subject 1 | 37 |
| Manager 1 | Employee 2 | Subject 2 | 55 |
| Manager 1 | Employee 3 | Subject 1 | 54 |
| Manager 1 | Employee 3 | Subject 2 | 44 |
| Manager 1 | Employee 4 | Subject 1 | 46 |
| Manager 1 | Employee 4 | Subject 2 | 28 |
| Manager 1 | Employee 5 | Subject 1 | 31 |
| Manager 1 | Employee 5 | Subject 2 | 51 |
| Manager 2 | Employee 6 | Subject 1 | 39 |
| Manager 2 | Employee 6 | Subject 2 | 28 |
| Manager 2 | Employee 7 | Subject 1 | 44 |
| Manager 2 | Employee 7 | Subject 2 | 25 |
| Manager 2 | Employee 8 | Subject 1 | 25 |
| Manager 2 | Employee 8 | Subject 2 | 39 |
| Manager 2 | Employee 9 | Subject 1 | 28 |
| Manager 2 | Employee 9 | Subject 2 | 40 |
| Manager 2 | Employee 10 | Subject 1 | 38 |
| Manager 2 | Employee 10 | Subject 2 | 37 |
I hope you got my query.... Kindly suggest.
Below link helps me to solved this query
5 Replies
You could create a hierarchy of Manager, Employee and drag this on to a matrix
Hi Anonymous ,
Do you want to get the output like below?
If not, please share your desired output so that we could help further on it.
Best Reggards,
Cherry
