0 Replies Latest reply: Jun 6, 2017 8:57 AM by Rob Buque RSS

    Split Expression or Show Only Total% in Pivot Table

    Rob Buque

      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.

       

      PivotTableResults.PNG