Get Free Trial

Flat view sorting with multiple columns is not working.

kumar asked on July 27, 2017

I tried to sort by column1 followed by column 2. once you apply the sort for one column, all other columns become random alphabetically.
it looks only allows to sort on one column and forgets any other column sorting. It should remember all sorting setup and apply those based on column position (first column first, then second column etc). It is working in pivot table classic layout but not in flat.
Please take a look and let me know whether able to recreate this or not. it’s happening in DEMO site also.
Thanks & Regards,

13 answers

Ian Sadovy Ian Sadovy Flexmonster July 27, 2017

Hello Kumar,
You are right, it the flat view you can apply sorting only by one specific column at a time.
Otherwise, the data in rows will be messed up.
Do you have an example how it works in Excel or other similar software?

kumar July 27, 2017

Hi Ian,
Yes, the same way it works in Excel with custom sort option. Column 1 then after column2 then…column N.
Please find an attachment with an excel example: Without Sort and With Sort tabs. Please let me know if you need anything else.
Thanks & Regards,

kumar July 27, 2017

Please find an excel example that I have attached.


Tanya Gryshko Tanya Gryshko Flexmonster July 28, 2017

Hello Sunilkumar.V,
Thank you for providing the Excel sample. Currently, sorting with multiple columns is not supported in flat view. This feature is not in our roadmap, however, we have added it to our customers’ wish list. We will keep you posted with any updates.

Ankit Agarwal April 2, 2018

Tanya – we are also looking for multi-sort capabilities in the flat-view. Any plans on adding this to the roadmap?

Dmytro Zvazhii Dmytro Zvazhii Flexmonster April 3, 2018

Hello Ankit,
Thank you for writing. For now, we do not have any plans on adding this feature to the roadmap. Still, we keep in mind that some of our customers have already requested it. Therefore, this feature may be added to the roadmap in future. We will notify you when the status of this task is changed.

Sergii Valko July 5, 2019

Hello. We also would be pleasure if you decide to add multi-column sorting to all view types.

Vera Didenko Vera Didenko Flexmonster July 5, 2019

Hello, Sergii,
Thank you for writing to us.
Our team would like to explain that our roadmap is full at the moment.
Please keep in mind that we will notify you in case of any updates on the matter. 
You are welcome to contact us in case of any questions.
Best Regards,

Richard January 14, 2020

This certainly is a much needed feature. I appreciate that it might not be trivial to implement for pivot tables, but for flat tables it’s a standard feature in most spreadsheet programs.
Best regards,

Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 15, 2020

Hello, Richard,
Thank you for contacting us.
Your suggestion sounds reasonable, and the task on creating such a feature is added to our backlog. However, our team would like to kindly inform you that our roadmap is full for the current moment.
We will keep you posted with any updates.
Please contact us in case additional questions occur.
Best regards,

Matthew V January 24, 2020

+1 for this feature

Vera Didenko Vera Didenko Flexmonster January 24, 2020

Hello, Matthew,
Thank you for your interest.

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.
Kind regards,

Vera Didenko Vera Didenko Flexmonster March 11, 2020

Hello, Kumar, Ankit, Sergii, Richard, and Matthew,
We are happy to let you know that multi-column sorting is now available for the flat table (use Ctrl + click to sort via UI).
Please see the following JSFiddle example for illustration:
This is available in the 2.8.2 version of Flexmonster:
You are welcome to update the component:
Please let us know if everything works fine for you.
Looking forward to your feedback.
Best regards,

Please login or Register to Submit Answer