Hello @KVlahovljak ,
Apologies, I was offline.
Well interesting. If you attach the workflow, I will add it. Its difficult just on visual.
I would say the you should replace the top part with the incoming data.
If you can attach workflow, it will be great. empty data if you have to.
@KVlahovljak ,
Have a look at the attached workflow.
Lets look at the order first and we will look at the variance.
If the order looks good to you, The join that you had was only oin the month but it should also include the year. This is why you were getting some duplicates and variance inconsistencies.
Well, have a look and let me know your thoughts.
BTW, well done on the way you added the months per year. this gives you the flexibility to have different order per year if you wanted.
Thank you so much for your help!!!
Got you. I think you need to move your multirow tool after the sort.
I attached the workflow for guidance.
An idea.
Hope it helps
You can change the order the way you want.
@ImadZidan Thank you so much!
Where would I add this in?