I want to calculate the grand total of a column in a calculated field in order to display the same number in all rows of the pivot table.
Lets say I have below table and I want to display 365+365=730 in all rows of the pivot table.
111 365 111 0 111 0 111 0 111 0 112 365 112 0 112 0 112 0 112 0 112 0