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.
Hi @Mo1995
Can you provide some sample input and expected output it will help us get a better understanding of the usecase.
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 ??
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |