How can I arrange my months into a specific order (Example from July to June)?

[KVlahovljak]

[ImadZidan]

Hello @KVlahovljak ,

An idea.

Hope it helps

[ImadZidan]

@KVlahovljak ,

You can change the order the way you want.

[KVlahovljak]

@ImadZidan  Thank you so much! 

Where would I add this in?

[ImadZidan · Accepted solution]

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]

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

[KVlahovljak]

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?

[ImadZidan]

@KVlahovljak ,

let me have a look, I am sure we will crack it.

[ImadZidan · Accepted solution]

@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. 

[KVlahovljak]

This is amazing, I made a change and now Sept has fallen out of my line up.  I double checked the numbers and have no idea why this is? Other than that it is perfect.   DO you know if the variance stays the same or recalculates based on the months?