Drop down filter of quarter based on Month selection

[kvr9]

Hi ,

I have an issue with populating the date filter i.e Month and Quarter.

I want it to be in drop down format(Used Pivot chart).

I want to give the default as Month when nothing is selected ,followed by Quarter.

Please find the attached example.

[isingh30]

Please check this. Let me know.

Thanks.

[kvr9]

Hi Jaume,

Many thanks that works as expected.

Can you please tell me the same output for Month filter.

Default should show Month upon selection of month/Quarter the respective should reflect(Including concat option)

[kvr9]

Hi Ishtdeep,

Thank you for your response.

The pivot table works perfectly,but I'm looking for a filter option (I.e individual representation of Year,Month & Quarter)

[isingh30]

Do you want to see one thing at a time in chart? You can do this in straight table with Cyclic group.

Thanks.