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.
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?