3 Replies Latest reply: Nov 16, 2010 4:06 PM by Vlad Gutkovsky RSS

    Pivot Hierarchy Subtotal

      I am trying to do a subtotal in a Hierarchy for a pivot.

       

      There are three steps attached is a sample in excel

       

      Total income has 6 children (and subtotal)

      other income total has 2 children( and subtotal)

      Total revenues has total income and other income total as its children( grand total)

       

      how would you set this up in QV?