7 Replies Latest reply on Feb 10, 2017 10:22 AM by Shinichiro Murakami

    Layout total grandtotal


      Hi Expert,


      I have a weird requirement. Cannot post the workbook due to data sensitivity but have created a dummy layout in excel and pasting it below -

      So as u see below the Amt1 column has values only associated at the Category Level.

      While the Amt 2 is broken down at the Item level.


      So is it possible to show the Amt 1 directly at the Total level. So currently its adding a null row under Item and showing the amount 1 as show in the second image below.

      Also how do I show the Grand total for two different categories and then again show another category after it as shown in the Final Layout below


      Is this even possible to show this way ?


      Final layout -


      Displaying NULL -