AnsweredAssumed Answered

Report without duplicates

Question asked by vincer on Oct 9, 2018
Latest reply on Oct 10, 2018 by vincer

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 ?