On the sample file, I would like the pivot table to look like Table 1 but have the "Tot" and "%NonStd" calculated expression split as separate total columns. My unsuccessful attempt is shown on Table 2 which incorrectly includes all the other percentages and not just the total %Non-Std as shown on Table 1. I'm open to any suggestions. Thank you.