Link to home
Start Free TrialLog in
Avatar of Dovberman
DovbermanFlag for United States of America

asked on

I need to create a sub total that subtracts instead of adds the detail values.

I have a matrix level 1 subtotal. I right clicked on a data cell that I wanted to total, and then Right clicked and selected Sub Total.

The sub total defaulted to the group sum. I need to display the difference.
How can I substitue an expression for the sub total ?

Example:
                                 
                                           Type A       Type B
      State 1        County 1     125           250
                          County 2     135           275
                          Diff              10              25    'the default is 160 and 525. I need to display 135-125 and 275-250

      State 2        County 3
                         County 4      Etc.

Thanks


ASKER CERTIFIED SOLUTION
Avatar of Dovberman
Dovberman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dovberman

ASKER

No Comment