Dynamic Year selection

[Nikhil2725]

Hi All,

I have the Below Data base.

ID	ID_Name	Total Quantity	Sales	Billing Year
231546	BV 546	36,910	1,127,668	2010
231546	BV 546	40,043	1,163,729	2011
231546	BV 546	45,000	115,253	2012

There are 3 years i.e 2010,2011,2012.

I need to give the option to the user to select any of the year in the UI. say Dropdown list for selecting the year.

Based on the year selection I need to display the data

If the user Select’s 2010.

I need to display

ID	ID_Name	Total Quantity	Sales	Billing Year
231546	BV 546	36,910	1,127,668	2010

Like Wise.. How can I do this??

Kindly help me in this.

[Kashyap_R · Accepted solution]

Hi 

Create a straight table with all the required parameters, the user can select the year directly from the table or you can create a filter for the year dimension.

Hope this helps

Thanks

[Nikhil2725]

Hi,

Thanks for the reply..

Have to give the user the option to select the year in the UI.

Based on the user selection I need to display the data...

[Kashyap_R]

Hi 

by creating a  straight table or filter users can interact and dynamically select the year.

Thanks

[lorenzoconforti]

As kashyap has said, just create a table and let the users select the year from the table itself; or you can have the year as part of a filter object

See example attached