I need assistance trying to find the % of a grand total to display on a pivot table. Please review the image.
The goal is to display the percentage of column C/ Grand Total(column B) ideally the values in column D. I cant use column D because the values will change each week and I had to hard code the grand total number in myself just to display the correct value.
When I try to run the code, instead of using the grand total of column B, it gives me just the value of column B (column E).
The grand total of column B is 33440, for Row 1, I need to run column C 56/33440 instead Sisense is doing 56/61.
Is there a way to store and use the grand total in a calculation?
Please sign in to leave a comment.