Hello All,
I have below Data (Department, Name and Value).
Expected Output -there should be another column which shows "Total Value" based on each department and when I collapse the group based on Department then it should show same value for column "Value" and "Total Value"
| Department |
Name |
Value |
Total Value |
| a |
a1 |
1 |
6 |
| a |
a2 |
2 |
6 |
| a |
a3 |
3 |
6 |
| b |
b1 |
4 |
15 |
| b |
b2 |
5 |
15 |
| b |
b3 |
6 |
15 |
| c |
c1 |
7 |
24 |
| c |
c2 |
8 |
24 |
| c |
c3 |
9 |
24 |
After Collapsing table based on Department-
| Department |
Value |
Total Value |
| a |
6 |
6 |
| b |
15 |
15 |
| c |
24 |
24 |
