Question Re: Filter on dropdown for DATE in Financial Management Q&A

Filter on dropdown for DATE

Former Member — Thu, 09 Jul 2015 13:06:34 GMT

I've created dropdown for DATE as follows in my Template

Bt my requirement is in this format so that it'll be easy for enduser to go through necessary dates easily.

I've tried excel filters bt itz not working for dropdown.I want it to be done in BPC like this.

Best Regards,

Mehul B. Magare

Re: Filter on dropdown for DATE

former_member186338 — Thu, 09 Jul 2015 14:28:30 GMT

Hi Mehul,

Sorry, but what are you trying to achieve? Where can I see the report layout? What do you want to filter?

Vadim

Re: Filter on dropdown for DATE

Former Member — Fri, 10 Jul 2015 04:55:56 GMT

Actually i've dates in my report for which i've created dropdown which is in the form 1-04-2015 k?
But if user have to go to some particular date then he has to search for the date, so i want it in tree format like 1st year will come 2015 and when we expand then months likewise days so that user will find it simpler to go to particular date.

Re: Filter on dropdown for DATE

Shrikant_Jadhav — Fri, 10 Jul 2015 19:01:06 GMT

Hi Mehul,

What type of report ? What is the output of selection ?

Can you explain your requirement with the help of screen shot ?

Are you using TIME type dimension for DATE?

Shrikant

Re: Filter on dropdown for DATE

former_member186338 — Fri, 10 Jul 2015 20:43:58 GMT

Screenshot? Not able to help without understanding requirements...

Vadim

Re: Filter on dropdown for DATE

gajendra_moond — Sat, 11 Jul 2015 05:02:00 GMT

Hi Mehul

This is one of the ways to get a date picker but not in the way you want but still pretty interactive. Hope that helps.

Excel Tips: Put a Calendar Date Picker on an Excel Worksheet

Re: Filter on dropdown for DATE

Former Member — Mon, 13 Jul 2015 05:08:24 GMT

Vadim , my requirement is to get filter on dates so that it'll come in hierarchy format i.e. year-mnth n den date format. With excel filter it is coming on header i.e. Day/month/year in my screenshot but i want it to be done in dropdown i've created for Date.

Mehul

Re: Filter on dropdown for DATE

former_member186338 — Mon, 13 Jul 2015 05:20:33 GMT

Unclear!

What is the relation between dropdown and filter? What do you want to select? What for?

Vadim

Re: Filter on dropdown for DATE

Former Member — Mon, 13 Jul 2015 05:41:38 GMT

I'm also confused with the same question but for client those date formats should be in tree format so they will be able to go through the dates easily..

Re: Filter on dropdown for DATE

former_member186338 — Mon, 13 Jul 2015 05:44:49 GMT

In VBA you can create form with TreeView with the required features...