Pivot Data list sum

[MP-iCONN]

I created a report that is able to show me amount shipped historically by Month-year.

The problem is when I pivot the data the Month-Year will change and I am not sure how to get the new months into my list sum totals by row.

Currently the step shows this (which will error because I now have 2021-12 to also sum):

= Table.AddColumn(#"Replaced Value", "Addition", each List.Sum({[#"2020-12"], [#"2020-11"], [#"2021-01"], [#"2021-02"], [#"2021-03"], [#"2021-04"], [#"2021-05"], [#"2021-06"], [#"2021-07"], [#"2021-08"], [#"2021-09"], [#"2021-10"], [#"2021-11"]}), type number)

One final question I have.  This new month won't show up in my table view visual either.  Do I have to go into this report each time to get the new month to be shown in table view?

Thank you for any help/advice.

Chad

[CNENFRNL · Accepted solution]

= Table.AddColumn(#"Replaced Value", "Addition", each List.Sum(List.Skip(Record.ToList(_))))