Sorting list items in Repeating Group

Need help
1

Hi,

I have a RG, displaying all menu items of a restaurant. What this RG displays is the aggregated numbers of the each menu items sold in a month as well as the aggregated sales amount of each dish, which looks like

MENU Agg. sold count Agg. $ sold
Item 1 12 $120
Item 2 8 $160
Item 3 10 $70
.
.
.

I want to add a feature that users can sort the list by “agg. sold count” or “agg. $ sold” in descending manner.

I put the expression for “agg. sold count” at the “Sort by” dropdown’s Change which field, but when I do that, the list won’t display.

Can anyone help me achieve how I can add this sorting feature?

Thanks in advance.

2

Is the agg. sold count value populated in the database for each of the restaurants?

Provide screen shots of the RG sort setup as well as the data type in use and the data fields plus perhaps a screen shot of the database data entries for the data type

3

This topic was automatically closed after 70 days. New replies are no longer allowed.