How to build data and rankings for pivot tables in DOMO

Hi guys, looking to build week on week report, but not sure what type of DATA format I should pre-create to be able to build things that would show like in this image. 


The Rankings Column is the one I'm unsure if it is possible 

1) adding a number

2) showing a calculation in the rest of cells


Please advise


  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴

    @Sandis , can you relink the image?

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"