Selecting

I have data of different month i want to filter out for the particular month like I working for July month data I want to filter out for July month.

I tried using filter tool but for that I have to change month in tool every month.

Can we some drop down or something and if we select the particular month it filter outs data for that particular month.

Month Test Data.xlsx

Workflow

Accepted answers

pdave87

@sgaryali hi, attached app can be very useful in such instance. Refer below test screen-print as example. You can perform test run on your data and let us know. Month selection is kept dynamic i.e. the drop-down list will provide the month in list for data that is available. Hope it helps 🙂

App_FilterDataBySpecificMonth.yxwz

pdave87

@atcodedog05 sorry, I thought the solution was left open and your responses crossed. Apologies.

@sgaryali refer @atcodedog05 analytical app. Happy solving!! 🙂

All comments

atcodedog05

Hi @sgaryali

Here is how you can do it. You can filter like below to check for current month.

Workflow:

Hope this helps : )

current month.yxmd

sgaryali

Hi
Thank you for your solution.

But by this I will be getting the data of the month in which I am working on it.

Like for October I will get October month data.

But I want some kind of drop down which has option from Jan to Dec and I will be able to select any month in that drop down

Like right now we are in October and I want to select data for July

atcodedog05

Hi @sgaryali

You build an analytic app like below.

Workflow:

Hope this helps : )

current month.yxwz

pdave87

App_FilterDataBySpecificMonth.yxwz

pdave87

@atcodedog05 I'm going your notes and adding to my learning. Thanks for your quick replies on community post as many of the questions are complex and I get to learn from your solutions. Super thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703