13 Replies Latest reply: Jul 22, 2015 9:57 PM by Jim Chan RSS

    how to create a subtotal in a straight table?

    Jim Chan

      HI there,

       

      I want to create a straight table with subtotalling. I mean - a total figure for my top 3 and a grand total figure in this straight table.

       

       

      Customer_Name

      Amount
      customer110
      customer29
      customer38
      Total of TOP 327
      GrandTotal

      50

       

      How can i achieve that using Dimension limits settings in straight table?  I wasnt able to get the top 3 total - 27, and only able to show the grand total and the balance amount of this.

       

       

      Rgds,

       

      Jime