I am having a reporting requirement to show TOTAL SALES and some other measures based on MATERIAL, in a table in Dashboard. But, since I am having lots of materials in the source, the requirement was modified to show the TOP 10 Materials based on TOTAL SALES.
Can you help me with a solution for this? I tried sorting in excel sheet, but not working. Is there any option to do this in Universe level.
Please note that my source is HANA.