This should be easy but I can't solve myself properly
In a table with some 70,000 records, four main fields of interest
-Year = Year (Date)
-Category_1 (stored calculated text)
-Category_2 (unstored calculated text)
I need to produce a report as list in a separate layout where I can show the total of Category_1 and Category_2 sorted descending by Year avoiding duplicates of Year
Any help please ?