How to create variables in crystal reports? (not crystal report enterprise)

[Former Member]

Hi,

I wanna create a variable as below...

sum(sale) where country = india

sum(sale) where country <> 'USA

I wanna use these measures in crosstab table.

how to create these. please help me

[Former Member]

I want as below....

Where sale is a measure object. I wanna calculate india sale and other countries sale and use it.

Thanks

Riaz

[Former Member]

Slight variation

Create formula

@country

If Country <> 'India' then 'Other' else 'India'

Then as Ido said use this formula as your crosstab column and then sum sales as summary of you category field

Ian

[Former Member]

Select filter exclude USA from data

[Former Member]

Hi,

I have created formula as you said

if country in( 'india';'russia') then 'asia'

else others

I used that formula in crosstab. But I didn't get the sum of both coutries. I'm getting only russia value.