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?
Hi @ImadZidan I have attached the workflow below. I tried changing the line up. I am trying to get it to sort from July to June order FY19 and July to June FY20 order and July FY21 to June FY21 order (Example: Jul, Aug , Sept, Oct, Nov,Dec, Jan, etc) all for FY20
As I think this through will the variance adjust based on this? I need to show the variance between July to August, August to September etc?
let me have a look, I am sure we will crack it.
