Display Top n by Dimension in Pivot table

     

    Attached document helps in displaying the Top n values by dimension.  In calculated dimension I am limiting to display Top 3 values for each value in first dimension. If you want to increase the Top n values to be displayed just replace N in the below expression.

     

    =aggr(if(rank(FAILURE) < (N + 1), TEST),LOCATION,TEST)

     

    Hope this helps others.

     

    Regards,

    Jagan.