I would like the assistance of you on how to create a TOP N query so I can summarize values that are lower than 10% percent of the total and "label" it as OTHERS as usually we do with excel.
Table example:
tblExpenses
idExpense
dateExpense
ValueExpense
StatusExpense
See attached picture of an EXCEL example.
[img=http://s33.postimg.org/884eq26rv/TOPIC_DOUBT.jpg]
Luthius
Table example:
tblExpenses
idExpense
dateExpense
ValueExpense
StatusExpense
See attached picture of an EXCEL example.
[img=http://s33.postimg.org/884eq26rv/TOPIC_DOUBT.jpg]
Luthius