Hello everyone! I am looking for ideas to subtract one row from another. I have a column for the "fiscal year" and another for the "hours" worked.
I want to compare the number of hours worked in a certain year with the number of hours worked in a previous year by subtracting them.
I want it to be DYNAMIC and to still be connected to all the other data I have. So for example:
"Fiscal Year" "Hours"
FY22 10
FY22 12
FY23 7
FY22 15
FY19 20
Then I want the (sum of hours worked in FY22- sum of hours worked in FY23).
Like so?
If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!
Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/
@Tala did the above solve your need? Kindly mark as accepted solution to close the thread. Thanks!