Forum Discussion
Matthew_Theis
Advocate II
Advocate IIRankx an Aggregated Fieldin a calculated column while ignoring others.
Hello all, I'm trying to rank customers by the SUM (Total POS $) and am having difficulty getting Rankx to work as I would like it to. I have the following table: In this case, what I would like...
AlB
Community Champion
Community ChampionCan you please share the table in the screen capture in text-tabular format so that it can be readily copied? Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).
Matthew_TheisAdvocate II
Advocate IIHere you are AlB Thanks in advance.
| pos_date | business_group | vp_area_description | pos_end_customer_name | Total POS $ | Total POS Q | Rank C | Rank Customers by Month | Rank Customers by Month by BG | Index |
| Friday, February 1, 2019 | CBG | EUROPE | ZYTEQ TECHNOLOGIES | 70 | 632 | #ERROR | 26519 | 12694 | 1823291 |
| Friday, February 1, 2019 | CBG | EUROPE | ZYTEQ | 197 | 2160 | #ERROR | 19180 | 9143 | 1823289 |
| Friday, February 1, 2019 | FEBG | EUROPE | ZYTEQ | 32 | 210 | #ERROR | 32680 | 8170 | 1823290 |
| Friday, March 1, 2019 | CBG | AMERICAS | ZYNEX MEDICAL INC | 17 | 400 | #ERROR | 23955 | 12577 | 1856519 |
| Friday, February 1, 2019 | CBG | AMERICAS | ZYNEX MEDICAL | 563 | 20000 | #ERROR | 12414 | 5920 | 1823287 |
| Friday, March 1, 2019 | CBG | AMERICAS | ZYNEX MEDICAL | 15 | 370 | #ERROR | 24527 | 12915 | 1856518 |