I have a calculated dimension FTE i need to get Total at the bottom of the pivot chart ? i have used aggregation function could any one of you suggest me how do i get total for calculated dimension?
Department | | FTE | Hours | Client |
Management | | 20 | 10 | 9 |
Creative | | 30 | 25 | 50.25 |
Media | | 28 | 30 | - |
Operations | | 260.29 | 22 | 26 |
Planning | | 40.64 | 12 | - |
Technology | | 91.82 | 13 | 225.5 |
Total | | | 112 | 310.75 |
| | | | |
| | | | |