How to transform data base on the value of the field?

[ChioNeng]

Hello all, 

I need to get the total each column of the date and create a new column that showing the date column base on the value of "PostingDate". Im trying around addtotals for this but i can't get my output. Many thanks in advance.

Input:

APPLICATION	Set	LEVEL	PostingDate	2020-05	2020-06	2020-07	2020-08	2020-09
App1	A	2	2020-08	1	6	5	4	4
App2	B	3	2020-08	2	2	2	2	2
App3	C	4	2020-08	1	1	1	1	1
App4	D	5	2020-08	4	8	8	10	7

Output:

APPLICATION	Set	LEVEL	PostingDate	2020-05	2020-06	2020-07	2020-08	2020-09	Latest
App1	A	2	2020-08	1	6	5	4	4	4
App2	B	3	2020-08	2	2	2	2	2	2
App3	C	4	2020-08	1	1	1	1	1	1
App4	D	5	2020-08	4	8	8	10	7	10
				8	17	16	17	14	17

[Nisha18789]

hi @ChioNeng , as per the data in the output table, | addcoltotals will be able to help. However, I do see a latest column in the end but you have not mentioned about it in the question, is it something you are trying to achieve as well?

[richgalloway]

Please share your query that uses addtotals. Have you tried addcoltotals?