Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | ||
Instead of bringing it as a calculated dimension, why don't you bring FTE as an expression which you can then easily show a sum for?
Best,
Sunny