how to get the region based on the product type?

[kvchowdary]

Hi
In my report i have a condition for one of the data item(Date) like product type in('a','b','c') the min(ac start date) for product id else min(ac pl start date for prod id)
For above expression i am getting the min ac start date(01-01-1985) for one of the product type

By using above condition i need to display the region like 'US','UK' and 'JAPAN',suppose the above product types one of the product type min ac start date is='01-01-1985' so that i need to display US like that(Based on the date i need to display the region in another column)

thanks

[HalfBloodPrince]

Create two calculation
1] one calculate your date part  product type in('a','b','c') the min(ac start date) for product id else min(ac pl start date for prod id)
For above expression i am getting the min ac start date(01-01-1985)

2] use the above calculation to calculate the country part

if(calculated_date ='01-01-1985') then
('US')
else if(calculated_date ='01-01-1999') then
('UK')
else
('JAPAN')

[kvchowdary]

Hi HalfBloodPrince,
Thanks for your response,
How to pass the date field without hardcoding the dates to second calculation?

Thanks