NEED HELP WITH SUBTRACTING ONE ROW FROM ANOTHER
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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).
- Labels:
- Alteryx Practice
- Data Science
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Tala did the above solve your need? Kindly mark as accepted solution to close the thread. Thanks!
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
