Does anyone have an alternative way to get the same results as an aggregated rank expression (with less of an impact on performance). We are using this in a pivot table (which unfortunately is pretty set in stone) and then deciding the aggregation by finding the dimensionality of the row.
Adding another level to client hierarchy is going to push this calculation to time out though so we are deciding whether or not it is going to be feasible to add this extra client level to the dashboard.
