jaak198New Member8 years agoRanking by multiple columns Hi, Below is a dummy table which summarises the data I am using. Village Customer code Spend Total spend by Customer Rank A 101 100 1500 1 A 101 200 1500 1 A 101 3...Show More
AnonymousNot applicable8 years agojaak198,Click "New Table" as shown in the screenshot below, then apply my first formula.Regards,Lydia
jaak198New Member to Anonymous8 years agoHi Lydia, Very strange, I am in Power Pivot but I don't have a "New Table" option available in the toolbar. Perhaps I have to add it in as an option? Ali.
Related contentRanking by Multiple ColumnsDuplicate rankingPower Query - Create column - Ranking within multiple columnsRanking KPI cardDynamic Ranking
