Hi mt,

I am sorry, but i am not understanding exactly what Data structure you will have for this use-case.

Can you show us more details where are you going to be pulling the Data from for these Columns that provide the SUM, such as "Orange",   Red, Blue, White, Brown, etc?

I presume this is pulled from some SQL Data in your Database, but can you show us a bit more details how are the Columns and cells going to be related with the SQL Tables from your Database?

-

If you plan to use a SUM calculation, and have each on its own row - something like that is not currently possible in our Plugin.

You can make a Formula Column - but it is not possible to use a SUM Calculation inside a Formula Column. ( if that is what you need)

And also, when you add a SUM to a column, it can only be as we have shown in an example from your other ticket, when you can add a SUM, it can only add up the Total for one column - not to have one different SUM in each cell.

Here are just a couple of Screenshots of one of our Demo Tables, you can also check this table on our Demo Back End Page here;

So if we filter to only show one specific Date - The table is going to only show the rows from that day, and also the SUM is going to follow that filter to only show the SUM of that filtered result.

But if you could show me a bit more details just to be sure if we understood what your goal is.

Maybe what we advised will already be enough for you to see if your use-case is possible ,if you need to have a different SUM in each cell for the same Column or not.

-

Thank you.