2 Replies Latest reply on Nov 18, 2013 4:31 PM by Nima Oftadeh

    Adding filtered sub-totals as line items above grand totals

    Nima Oftadeh

      I'm looking to create a crosstab of my source data which has sub-totals filtered on specific criteria as rows above the grand total at the bottom of the table, but the table should show all entities. Each entity is grouped in a couple of different ways in the raw data as seen in the attached dummy data TWBX file. My target output would be something like (note: numeric values in the attached file differ)...

       

      20122013
      Apple1

      10

      Banana211
      Plum312
      Boat413
      Car514
      Chicken615
      Cow716
      Sheep817
      Total without Fruits3075
      Total without Fruits or Sheep2258
      Grand Total36108