Coda Way - Month on Month Changes of Top 10

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.

Screenshot 2022-03-07 192638

Is there a Coda way to achieve this more efficiently?

Any Coda experts here can help? :smiling_face_with_tear:

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.

Here it is

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



This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.