Forum Discussion

RMDNA's avatar
RMDNA
Icon for Solution Sage rankSolution Sage
8 years ago

Dynamic rankx() with filters

Hi all,   I've looked into other rankx() posts, but they seem too simple for what I need. Providing a PBIX would be difficult - this has a lot of tables and data, and I can't possible sanitize ever...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi RMDNA,

 

I was looking at your data and got some questions what is the value over wich you want to rank the information (Total Sales - Product table or Sales Quantity - Customer sales) and what do you want to rank the customers or the products?

 

Regards,

MFelix

RMDNA's avatar
RMDNA
Icon for Solution Sage rankSolution Sage
8 years ago

MFelix,

 

I'm looking to rank products by sales quantity.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    I'd like to help.  Please share (in a Table) the exact numbers that you are expecting.