Hello,
In my pivot table I need to combine the values of 4 and 5 (which are the 10 and 7) in row 17 and 18 so that the actual % is 17/36 which is 47% vs each row's % of the total as that does not add to 47%. I can't seem to figure out how to write this as a formula in the pivot table or if there is a get pivot way to do this? Prefer inside the pivot table.
Thank you.
In my pivot table I need to combine the values of 4 and 5 (which are the 10 and 7) in row 17 and 18 so that the actual % is 17/36 which is 47% vs each row's % of the total as that does not add to 47%. I can't seem to figure out how to write this as a formula in the pivot table or if there is a get pivot way to do this? Prefer inside the pivot table.
Thank you.