🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

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

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

Ian Sadovy 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.

Please login or Register to Submit Answer