How to set the default value

[pranubitla]

Dear Experts could you please shed some light on this please

setup the default value for a below PRODUCT field in script level.
example:

  I am loading list of 3 columns from spread sheet, I would like to setup a default name COUNTRY = 'USA' in my country column for Laptops only

I've all list of countries but want to set to COUNTRY = 'USA'  for  'Laptops'

PRODUCT	COUNTRY	AMOUNT
Mobiles	CHINA	3045
Laptops	UK	3456
Desktops	JAPAN	1012
IPADs	USA	9834
Laptops	France	3462
Laptops	India	3423

[awhitfield]

HI Pranu,

can you expand a little on what you actually mean by 'default value'?

Andy

[pranubitla]

I've a list box name called  'PRODUCT'  I got 3 types of products

when I select Laptops I should only get USA, even though I got  data like China, UK, Inida... all converted to USA, 

Original Data:

PRODUCT	COUNTRY	AMOUNT
Mobiles	CHINA	3045
Laptops	UK	3456
Desktops	JAPAN	1012
IPADs	USA	9834
Laptops	France	3462
Laptops	India	3423

Front end result should look like below

PRODUCT	COUNTRY	AMOUNT
Mobiles	CHINA	3045
Laptops	USA	3456
Desktops	JAPAN	1012
IPADs	USA	9834
Laptops	USA	3462 Hope
Laptops	USA	3423

[awhitfield · Accepted solution]

Use a calculated dimension for your country field in a chart e.g.

=if(PRODUCT = 'Laptops','USA', COUNTRY)

Andy

[awhitfield]

Glad to be able to help!

[pranubitla]

Really appreciated your prompt reply.