How to replicate Pivot Table experience in Coda: summing within the pivot and for rows/columns

[Jean_Pierre_Traets]

Dear @Robert_Collett, great that you took the opportunity to get in touch with the community

It would be great if you could share a dummy copy of your doc, so somebody in the community will be able to pick up from there.

Maybe this post is a good inspiration:

How can I formulaically point a column of a table from a formula of another table?

@Juan_Luis_Chulilla Play with this and see if it’s useful for your scenario. If it’s more than you require, you can just use SwitchIf() in your filter to iterate over the columns. EDIT: Forgot to specifically answer your question – to my knowledge, we don’t yet have programmatic access to columns.

If the content is sensitive, I suggest to get in contact with support@coda.io and they will be glad to come back to you.