Sort Desc on a Column Value && Filtering out 0 values

First Question: I have a column, color, it has values of red, blue, yellow, green. I want to sort the color column by descending.
Second Question: I have a two values, Price & Quantity it has a few 0 values, I want to filter out where Price = 0 or Quantity = 0
jsfiddle example would be nice thanks

3 answers

Iryna Kulchytska Staff May 4, 2016

Hi David,
First Question: Here is a sample: Just add sortName: “desc to color column in the report object, as follows:

columns: [{uniqueName: "Color", sortName: "desc"}]

Please let me know if it is what you were asking about.
Second Question: There is no option to filter out zero values in the component.
Kind regards,

Public May 4, 2016

2nd question: is there a way to filter, where quantity greater 3 for example?

Dmytro Zvazhii Staff May 5, 2016

Hello David,
Thank you for your question.
Unfortunately, there is no feature in the component which allows to do that.
Best regards,

Please login or Register to Submit Answer