Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can i perform top 10 record display in pivot table is it possible or not
Considering your have Customer vs Sales Data
Use Below
Pivot Table
Dimension
Customer
Expression
SUM({<Customer = {"=Rank(SUM(Sales),4)<=10"}>}Sales)
Considering your have Customer vs Sales Data
Use Below
Pivot Table
Dimension
Customer
Expression
SUM({<Customer = {"=Rank(SUM(Sales),4)<=10"}>}Sales)
thanks....