4 Replies Latest reply on Aug 9, 2012 6:08 PM by yao.fu

    Select Rows for Subtotal

      Hi All,

      Recently I have met a disturbing problem. Here is the thing:

      I need to keep a cross table format to meet with a standard excel template. However when calculating subtotal for a  Type ,there is  a detail information about Level. I only want to add amount of those Level = 1 as subtotal ,but have to show those Level = 2 at the same time.

      Really appreciate if you can help me with that! 

      Capture.PNG

      P.S : For example, the total for 04 Operating Costs should be BR+CR+OOU. And I can not change the format of the sheet.