Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
FirstSortedValue(([customer Name]), ( Count(sales date), Rank([Customer Name]),1))) this does not work in KPI , to get the top 1 customer .
Try with:
FirstSortedValue([customer Name],aggr(-Count(sales date),[customer Name]))
thanks, I was able to get the top 3 products, but I wanted to get the top 3 customers for those top products.