I may have misundestood this but if you go into the table properties > visibility tab you could add an expression along the lines of below to define whether the...

ah, I didn't realise that you were working with a Matrix not a Table. I don't know how to merge those columns I think they are just driven by the...

if that's the case then you can select/highlight the four cells in the row where you would like the heading to appear then right click and select 'Merge cells' this...

Hi try the following example, a table is created with the dummy data in and then an update is performed on the table where the table is joined into itself...

Hi,

I may be misunderstanding this but are you trying to merge the heading values in the row above to cover the four columns?

Could you do a sum on the values where the invdate equals the max invdate within the month grouping, something along the lines of,

SUM(IIF(invdate = MAX(invdate,"Month"),InvBalance,0)

Hi,

if you have the row number for the table already you could join this table in on itself as below allow you to join one row to the next

SELECTtable1.column1,

...

I think you will have to declare the CTE for each insert as below, I don't think that the CTE can be shared between two seperate select statements.

WITH CTE1(col1,col2)

AS

(SELECT col1,col2...