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

Make Compact/Classic view look like Flat View

Matthew V asked on January 24, 2020

We have been using the Flat view to display our data, and this has many of the features we required. However, we need to be able to do multi column sorting.
Based on other recent forum posts: https://www.flexmonster.com/question/flat-view-sorting-with-multiple-columns-is-not-working/ this doesn’t appear to be on the roadmap. (Would love if it did)

Is there a way to get Classic/Compact view to look like the flat view. I cannot get the “Totals” to go away in classic compact. I want 1 row per row of data passed in. This fiddle is what I have been working on. If I just switch it to flat, that is how I want my data displayed, but then I can’t do a multisort by locationString and busnDate

3 answers

Vera Didenko Vera Didenko Flexmonster January 24, 2020

Hello, Matthew,
Thank you for reaching out to us.
Please kindly note that our roadmap is full at the moment.
However, our team has taken your request into consideration and we will notify you in case of any changes.
Regarding a way to get the classic/compact view to look like the flat view:

1. How to remove the “Totals”:
Flexmonster provides an option to hide aggregation labels like “Total Sum of”, “Sum of”, etc. in the column/row titles.
This can be done by setting the showAggregationLabels parameter to false, for example:

options: {
showAggregationLabels: false

2. Applying CSS styles:
CSS styles could be applied to make the classic/compact layout’s headers to look more like the ones for flat. The additional CSS rules can be applied via the customizeCell() hook.

Here is a modified version of the JSFiddle example where the “Totals” are turned off and additional CSS rules are applied: https://jsfiddle.net/flexmonster/Lkjr9u1z/
Please let us know if this helps.
Best regards,

Matthew V January 24, 2020

Thank you for the reply, but this doesn’t give me the results in the grid that I am looking for. I want one row in the grid per “row” (object) of data in the sample json (expecting 21 rows in the grid, I don’t want it rolled up into 3 rows by locationString). I don’t want the aggregation/sum of any of the data. I want it to display all of the rows like the flat view does.

Vera Didenko Vera Didenko Flexmonster January 27, 2020

Hello, Matthew,
Thank you for your response. 

We would like to explain that the described layout is not supported at the moment.
In classic and compact layout, data is aggregated and fields are grouped as a result.
Please kindly note that currently, it is not possible to combine classic/compact and flat layouts.
We will keep you updated in case of any changes regarding the multiple columns sorting feature for flat layout.
Please let us know if you have any other questions.

Kind regards,

Please login or Register to Submit Answer