Our customers would really love to be able to filter and sort on calculated columns.
Is that on the roadmap anytime soon? We are using Flexmonster json data version.
Thank you for writing to us.
Our team would like to explain that calculated values can be sorted and filtered in Flexmonster just like other value Fields.
Please see the following JSFiddle for illustration: https://jsfiddle.net/flexmonster/a872pt91/
In the provided example, the
"My Calculation" calculated field is sorted in ascending order and the values are filtered to include only those that are greater than 1000000.
Please let us know if this works.
You are right, it does appear to work for Pivot View. But our customers need it for Flat View. Is that possible?
Thank you for your reply.
Our team will add support for sorting calculated values in
This update will be available in the minor release version with the ETA 19th of October.
As for filtering calculated values in
flat layout, we have added your request to our customers’ wishlist. We will notify you in case of any updates on the matter.
Please feel free to contact us in case questions arise in the meantime.