Create a new row by multiply one row with a number

Question

Greeting everyone,

I have a data set that looks like below

District2021202220232024Site A24232526Site B50484951Site C65201921Total 2160211321162122

I am trying to create a new last row with data that multiply the "Total" row with the same coefficient of 0.94.

Any suggestion of how to do it? Thanks in advance.

DavidP · Accepted Answer

Hi @esun1028

Something like this perhaps?