How to show Grand total only for specific columns in flat type report?

Answered
Kranthi asked on August 7, 2019

I want the the Grand Total to be shown only for the columns I want to be shown in Flat type report.
For example I have columns like
Customer, Year and Net amount and GrossAmount, 
I want the Grand Total to be calculated only on Net amount and GrossAmount, I dot want the Grand total to shown for the column Year.
 
 
 

1 answer

Public
Ian Sadovy Flexmonster August 7, 2019

Hello Kranthi,
 
Thank you for the question.
Here are two options for your case:

  1. Change the data type of Year column from number to string. Grand totals are shown only for numeric columns. Documentation about data types for JSON.
  2. Use customizeCell to hide specific values on the grid.

Please let us know if it helps.
 
Regards,
Ian
 

Please login or Register to Submit Answer