Mega Table Rank interactions with PDP

M_Gonzalez

Hi all,

I am trying to build out a dashboard that lets vendors compete with each other in a mostly anonymous way. One example would be a section that shows the logged in vendor their 7 Day Sales Rank, compared to their 28 and 91 Day Sales Rank.

Key requirements:

• Vendors should be able to see their rank only; not any of the other suppliers
• When a user selects one or more filters, the ranks must dynamically recalculate

If I were to apply PDP in a way that limited vendor to only seeing their sales data, my understanding is that it would inherently remove all sales data making the ranks = 1 for all time periods.

Is there a beast mode or some other way that would allow me to get the result I am showing in the attached image? If not, would column masking allow me to anonymize all vendors excluding the one who is logged in?

Calculating these ranks in ETL seems like the obvious choice, but (I think) it would force us to build 100's of specific rank columns for all of the filter and date range combinations

@ColemenWilson @MarkSnodgrass @GrantSmith , you all have answers for seemingly any question I see asked on here… thoughts on the above?

Thanks in advance.

ColemenWilson

Dynamic ranking is possible, but like you said would show a rank of 1 when PDP is applied. You could use Column Level PDP to hide sensitive data about other vendors. I think Column Level PDP is still in Beta but you could reach out to your CSM to see if you could try it out.

I like doing ranks in an ETL. Is there a way you could get what you need by limiting the functionality on the page of selecting multiple vendors?