SOLVED
adding a Sub total row
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Mo1995
6 - Meteoroid
‎10-21-2021
04:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have the following data set
I want to run a sub total row for each year's transactions:
here's how the data looks :
this is the desired output:
one last remark, I want the expression to be dynamic not just a reference for those 2 specific years
and note every 4 rows repeat for each year
any thoughts ??
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
5 REPLIES 5
22 - Nova
‎10-21-2021
04:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Mo1995
Can you provide some sample input and expected output it will help us get a better understanding of the usecase.
‎10-21-2021
04:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
22 - Nova
‎10-21-2021
04:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎10-21-2021
04:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes that worked right away I appreciate it
I just have one more question
would this workflow still work If I added more years like 4 rows for 2017,2018 and so on or do I need to modify the formula ??
22 - Nova
‎10-21-2021
04:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
