Filter out previous quarter plus other columns

[ankush-agrawal]

Hello All,

Thank you for reading my question, first of all.

I have a data with attached columns in screenshot.

I would like to have below column as extract by applying filter:

Department

Previous Quarter: Q3_CY (As of today)

Definition of Previous Quarter:

This working is performed quarterly in April, July, October and January

(Since I am creating a workflow for the first time, I am standing in December now)

So, previous quarter means:

April: Q1_CY

July: Q2_CY

October: Q3_CY

January:Q4_CY

[grazitti_sapna]

@ankush-agrawal , here is my solution if this is want you needed. You can dynamically select columns using dynamic select tool and specify the formula as per your conditions.

[Blainelop25]

Returns a previous quarter. ... the Date column is often used to define relationships with other tables, to be easily used in CALCULATE as a filter. Live IQ Subway Mobile