1 Reply Latest reply on Nov 30, 2016 5:55 AM by lenaic.ridinger

    Add a Calculated Row For Custom Subtotaling

    Devin Pullman

      I'm trying to perform custom subtotaling on sales data to give a total for US and Non-US sales offices. My worksheet looks like the table labeled "current" and I am trying to make it look like the table labeled "desired result"

       

      When I tried to group the sales centers as US and Non US the pill (dimension) was greyed out. After googling through a bunch of threads I found that grouping was not supported for secondary data sources. Is there anyway to do a manual calculation in the table calculations to add a row or do custom subtotaling?

       

      CurrentQ1Q2Q3

       

      Q4

      Beijing100150200250
      Guangzhou200250300350
      New York50100150200
      Los Angeles150200250300
      Grand Total5007009001,100

       

      Desired Result
      Q1Q2Q3Q4
      Beijing100150200250
      Guangzhou200250300350

      New York

      50100150200
      Los Angeles150200250300
      Grand Total5007009001,100
      Total US Row200300400500
      Total Row300400500600