I’m trying to rank a value within a pivot table to be able to then reference it in a calculated field. I’ve been unable to use the ‘Value Field Settings’, ‘Show Value As’ steps to reference the rank and after some help from ChatGPT, it seems I need to create a measure to rank the value via Power Pivot.

First, I am working with various security confines at our organization. A few years back we hit the Row limit for Excel pivots. I discovered a ‘POWERPIVOT’ but am no expert. It got the job done. As we have grown so has the data set the powerpivot uses. The sucker has 60 columns and 18M rows. It a workhorse that is used daily. There are no columns they are willing do get rid of. The data is aggregated to the lowest level possible. The sucker essentially houses our Business Structure, employees, locations, widget numbers/descriptions and chgs/pmts/adjs. Once opened its very fast. The issue is it is taking a while to refresh…half hour…and we refresh it weekly….not the end of the world mind you but I am starting to question if perhaps there is a better way or tool.