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 ?

                                           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.


Avatar of Dovberman
Flag of United States of America image

Link to home
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


No Comment