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

Create report as a Excel Grid

Sidath asked on April 30, 2019

I wonder whether I can create a report as an Excel Grid. Refer attached Excel file. This is not a Pivot Table, it is just a grid.

Job Deatils.xlsx

1 answer

Vera Didenko Vera Didenko Flexmonster April 30, 2019

Hello, Sidath,
Thank you for your question.
In Flexmonster one can create a report as an Excel Grid by setting the grid type to “flat”:

options: {
grid: {
type: "flat"

All values in flat mode are shown in a simple table, row by row (fact by fact) the same way as they come from the data source.
The user can choose what columns should be displayed in the flat table and the order of columns, filter by value or members’ names, sort values and use other data analysis tools.
Here is a JSFiddle example for illustration.
Please let us know if this works for you and if you have further questions.
Best Regards,

Please login or Register to Submit Answer