Coda Way - Month on Month Changes of Top 10

[Hendrik_TnB]

Dynamic Month on Month changes of top 10 customers in the last month/quarter/year

I have following chart showing sales changes (delta) month on month (thanks to @Christiaan_Huizer)

Now I want to show the sales changes (delta) chart of top 10 customers in the dataset based on dynamic filter (i.e. top 5 , 10 , 15 of sales throughout the period)

Currently, I’m using manual way. I created another table to summarize the top 10 customers of daily sales detail and choosing the customer code manually.

Is there a Coda way to achieve this more efficiently?

[Hendrik_TnB]

Any Coda experts here can help?

[Nick_HE]

Would you be able to share a version of this doc that we could play with? It might help us get a better sense of how things are built.

[Hendrik_TnB]

Here it is

Admin · Copy of Accounting - ESJ

[Hendrik_TnB]

Ah, I solved it finally by using 2nd table as helper and put this on the filter chart formula.