I unable to display top 5 selling menu items in a RG by Sort the sum of total sales for a selected period .
Table1 : Menu Item
Table 2 : Menu Sales
from the Above Lists, I would like to show top 5 selling Items in those two days (or a month) in a repeating group.
My expected output must be in RG
Logic I used:
To extract the unique Items, I used type as Menu Item table in the RG and extracted the sum of sales from Menu sales table for the current cell Menu Item.
I tried using Dynamic sort… but seems like I missed some Logic.
Can anyone please advice?