To get dimension field values in KPI for dim having highest sales, use MAX function with GROUP BY clause.

• Use MAX function to get the highest sales value for the dimension field

• Use GROUP BY clause to g...read more