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.
Thank you for your question.
In Flexmonster one can create a report as an Excel Grid by setting the grid type to “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.