Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

How to show sub total and grand total?

Answered
Deo Bernal asked on March 17, 2020

How to show sub total and grand total similar to the attached color coded computations.
 
Please see attached json sample data for your reference.

2 answers

Public
Deo Bernal March 17, 2020

Please see attached json sample data for your reference.

Attachments:
csvjson.json

Public
Vera Didenko Flexmonster March 18, 2020

Hello, Deo,
 
Thank you for providing a sample data set and giving us some time.
 
We would like to explain that at the moment the desired output can be achieved by displaying the three sections (the data table, airline totals, and sales totals) separately. Each section can be displayed in Flexmonster by applying a different data slice.
 
Please see the following JSFiddle example we have prepared for you: https://jsfiddle.net/flexmonster/ejb8t7kp/
 
We would like to add that to achieve the closest to the provided screenshot result, we have made a few changes to the data structure:
Instead of:

{
"AIRLINE": "sample airline",
"STATE": "ACT",
"Year": "2017",
"DATA": "Passengers 2017",
"JAN": 0,
"FEB": 0,
"MAR": 0,
"JUL": 0,
"AUG": 0,
"SEP": 0,
"OCT": 0,
"NOV": 0,
"DEC": 0,
"Grand Total": 0
}

We kindly suggest the following:

 {
"AIRLINE": "sample airline",
"STATE": "ACT",
"Year": "2017",
"Month": "JAN",
"Passengers": 0,
"Sales (Fares Only)": 0
}

 
Please let us know if this helps.
You are welcome to write to us in case any additional questions arise.
 
Kind regards,
Vera

Please login or Register to Submit Answer