Skip to Content
0
Former Member
Feb 25, 2011 at 03:13 AM

How to set current year,month as default value in combo box

45 Views

hi, im newbie of xcelsius user

i realize that hv a issue that display combo box base on year & month

let said

<b><u>step 1</u></b>

I create excel data like this

<b><u>year___ </u> </b> | <u><b>month_ </b></u> | <u><b>Product</b></u> | <u><b>revenue</b></u>

02-04-09 | 02-04-09 | a | $4,154

03-04-09 | 03-04-09 | b | $6,813

04-05-09 | 04-05-09 | a | $9,875

05-06-09 | 05-06-09 | b | $6,813

06-04-10 | 06-04-10 | a | $6,813

07-04-10 | 07-04-10 | b | $9,875

08-06-10 | 08-06-10 | a | $9,875

22-06-10 | 22-06-10 | b | $6,813

<u><b>Step2</b></u>

Then i go format cell to format/custom date to year & month

Eg1: Year u2013> 02-04-09 convert to u2018YYYYu2019 (2009) Eg2: Month u2013> 02-04-09 convert to u2018mmmmu2019 (April)

So output like this

<u><b>year</b></u> | <u><b>month</b></u> | <u><b>Product</b></u> | <u><b>revenue </b></u>

2009 | April | a | $4,154

2009 | April | b | $6,813

2009 | May | a | $9,875

2009 | June | b | $6,813

2010 | April | a | $6,813

2010 | April | b | $9,875

2010 | June | a | $9,875

2010 | June | b | $6,813

But the problem is when i insert to combo box,use u201Cfilter Row u201D, i excpectation will display only 2009,2010

But Actual display the Year in combo box is duplicated :'(

so any solution ? and then only how to set current year & month as default value :'(

thanks,

regards

s1

Edited by: Leong Pui Kee on Feb 25, 2011 5:25 AM

Edited by: Leong Pui Kee on Feb 25, 2011 5:36 AM