3 Replies Latest reply on Jun 7, 2016 8:22 AM by Manikandan S

    Is it possible to add a custom row for sum of particular rows after the grand total?

    Manikandan S

      My data source is Excel file. I imported the data from Excel file and I have three rows(High, Medium, Low). Each row have some values. I can generate grand total column wise for these rows. I want to add custom row after the grand total which will have value from sum of rows from the column. Please refer the below image.

       

      calculated-field.png

      In the above image, I have rows called High, Medium, Low. Each row have some values depending upon the month. Here I want to show sum of High and Medium for each month. How can I do? Please advice.