Account chart displaying sum over horizontal columns

I’m trying to create a chart from a table that lists accounts, and has either single values for each row in the columns that follow or sums of the columns. The table should display min and max values vertically, and should display the month columns horizontally.

Anyone know how to do that?

Hi Storm, and welcome to Coda!

I’m struggling to understand your request, can you provide a bit more detail? One thing I can see is that the table design will struggle when you have things that should really be rows (i.e. months) specified as columns (see this post, for a similar issue: Listing all columns that are not blank)

Maybe this helps?

Hi Nick, thanks for the solution! It’s a little complicated, but it does exactly what I was looking for. Appreciate the help :slightly_smiling_face:

1 Like