I am trying to pivot the org code and the End lease liability balance to know the sum of the end lease liability balance for each org code.
However in the manual aggregation tab, I cannot locate the column end lease liability balance to sum up the data.
Can I know what is my error?
to do the aggregation sum you should change your ‘string’ column to number.
before connecting the pivot node, attach either a string-to-number node or a table-manipulator node and select the column that you need to change to a number for the calculation.