Split Expression or Show Only Total% in Pivot Table

Mon, 05 Jun 2017 21:19:34 GMT

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.

topic Split Expression or Show Only Total% in Pivot Table in QlikView

Split Expression or Show Only Total% in Pivot Table