Pivot Hierarchy Subtotal

[#1]

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?

[vgutkovsky · Accepted solution]

See attached solution.

Regards,

[#3]

Vlad,

I am sure this works fine but unfortunately I have the personal edition. I am in the process of building a POC in hopes to get our company to purchase QV.

[vgutkovsky]

So you can't open it? You might be able to use one of your Recovery attempts to open the file. I think you are allowed to "recover" 3 or 4 files with Personal Edition. Otherwise, yeah...you need a license.

Regards,