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.
Thank you for the question.
Here are two options for your case:
string. Grand totals are shown only for numeric columns. Documentation about data types for JSON.
customizeCellto hide specific values on the grid.
Please let us know if it helps.