Forum Discussion
Pivot table ranking function always return "1" when using two rows
Hi There, I have created a pivot table using data pulled from a data model consisting of two different tables. It's basically a report that list customer names and their sales for different prod...
The problem is that ranking works within the combination of ID and name, you can get ranking to work again if you collapse the entire ID field, but that will hide the names. The only way I can think of is to create a combined name and ID string column and use that in the pivot table. You could do that easily in your current query by merging the first two columns.