Just starting out with Coda so apologies if this request is basic, but really struggling to get a handle on the Lookup concept.
I have two tables containing financial information for two separate companies. For each company view I have revenue as columns and financial years as rows. I want to create a consol table where I have the company as a row, financial years as columns, and shows the revenue in this table by customer & year (so I can then chart it).
Any guidance / help as to how to do this would be much appreciated.