Suggest an idea
Suggest an idea
What would make Nectari Software more useful to you?
30
Would like to be able in a worksheet to filter on a group (based on the subtotal value)
worksheet
Under review
November 15, 2022
It would be nice if we could filter based on the sub-total values. As an example we display all the years and within the years you got the total amount by customers and I would like to keep only the customers that got a total amount greater than 50k.I would like to have the total by year to be adjusted based on the customers that are filtered, so even if you got 1 customer at 60k and 1 at 40k for a year, the year should display only 60k and under it only 1 customer...
10 Comments
Scott
2 years, 14 days ago
Have had requests for this since details are not zero but group total might be zero and unable to filter out the entire group!
Reply
Rakavy Ravisingam
284 days, 3 hours ago
'HAVING statement in the web views' has been merged into this idea
Reply
Rakavy Ravisingam
274 days, 2 hours ago
'HAVING clause in Web views and other places' has been merged into this idea
Reply
Rakavy Ravisingam
2 years, 14 days ago
Status updated to 'Under review'
Reply
Peter
2 years, 14 days ago
The end-user would like the ability to filter based on Gross Profit %, however, since GP% is a field derived from OnCalculate they are note able to filter in the view based on GP%. It would be great if you could add the ability to filter based these types of fields.
Reply
Rakavy Ravisingam
284 days, 3 hours ago
'Having Clause' has been merged into this idea
Reply
Rakavy Ravisingam
284 days, 3 hours ago
'HAVING Clause in the Web-views' has been merged into this idea
Reply
Scott
2 years, 14 days ago
Example while training client today was they wanted only customers with sales over 50 thousand and margin% greater than 35. Only able to do if we create a new summarized SQL view by customer/year/month instead of using the Invoice Analysis data model. Nice to filter at group level but still be able to drill down into details.
Reply
SLAVA.SUKHOY
one year, 177 days ago
Also, would be good to be able to sort by the groups summary values (total amount, count distinct etc.)
Reply
BEN.ELLIS
162 days, 18 hours ago
Please add this, would be very helpful
Reply
Thanks for your feedback