sum Latest quarter value

[pokhan27]

HI Expert, 

i tried to create a work flow which gives me total quartelry values but when i tried to run the workflow the there is an issue with the quarter value as the i am only able to get the value from August month instead of getting the value of Aug+Sep+Oct. 

I am not able to figure out what is the issue with the flow. Please help

[atcodedog05]

Hi @pokhan27 

I dont know whats the issue in the previous workflow but I am getting in my current workflow. Please take a look 

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @pokhan27 

I can see your data doesn't have data for Sep & Oct 2021 that's why you are not seeing it.

Hope this helps : )

[pokhan27]

my bad in early cross tab i didnt select sep and oct..... 😞

[atcodedog05]

No worries 😅

Happy to help : ) @pokhan27 

Cheers and have a nice day!

[binuacs · Accepted solution]

@pokhan27 for Oct and Sep the year + Quarter is 2020  Q4 and you are filtering 2021 Q4

 

[pokhan27]

can we derive the ytd from the same workflow? 

[atcodedog05]

Hi @pokhan27 

Groupby year and sum it you get ytd

Workflow:

Hope this helps : )