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