Query editor
WITH-- Holders dashboarddashboard AS ( SELECTRANK() OVER(ORDER BY SUM("💰 (FTM)") DESC) AS "Rank 🔰","Address",SUM("💰 (FTM)") / SUM(SUM("💰 (FTM)")) OVER() AS "Share (%)",'|' AS "|",SUM("💰 (FTM)") AS "💰 (FTM)",SUM("💰 (sFTMx)") AS "💰 (sFTMx)",SUM("💰 ($) at Round End") AS "💰 ($) at Round End",SUM("💰 ($) at Distribution") AS "💰 ($) at Distribution",SUM("💰 ($) at Round End") / SUM("Value (💲)") AS "ROI",' |' AS " |",LISTAGG(FORMAT('%s : %,.1f', "Symbol", "Amount (🤡)"), ' | ') WITHIN GROUP (ORDER BY "Project 🔰") AS "Amount (🤡)"FROM query_3719276WHERE _rn_qual_project <= 6GROUP BY "Address")SELECT * FROM dashboardORDER BY "Rank 🔰"