sum Latest quarter value

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

OTC sample.xlsx

OTC WORKFLOW SAMPLE.yxmd

Date Time

Accepted answers

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

Hope this helps : )

OTC WORKFLOW SAMPLE (1).yxmd

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

All comments

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 : )

tetsing (3).yxmd

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

Hope this helps : )

OTC WORKFLOW SAMPLE (1).yxmd

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

No worries 😅

Happy to help : ) @pokhan27

Cheers and have a nice day!

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

can we derive the ytd from the same workflow?

Quick Links

Tags

This months top contributors

Hollingsworth 335