Calculated dimension? or where clause in dimension?

[#1]

I would like to use a dimension that looks something like this:

I got 2 fields Gtext and Gage, and would like to get GText where GAge = 15?

Is it possible?

[#2]

put this condition in your script

Load

GText,

GAge,

if(GAge=15,GText) as GText1

resident table1;

[#3]

You can use the expression In dimension calculated or in your expression

IF(GAge = 15, GText)

[#4]

Hi

I think I explain the whole situation wrong, so I start all over.

I want a chart to show how many there are of a certain age.
My field is PAge and I want to show how many there are at age 15, 16 and 17.

I know I could just make a count and filter the field PAge, but I need to make more charts on the same Sheet with another age range 18 - 24. Hope you get my meaning.

I have tried to use mapping load inline in the script but cant make i work

[#5]

Being very impatient I think I got a useable solution.

Using your ex. for calculated dimension - I tried this

=If(PAge=15, PAge) or If(PAge=16, PAge) or If(PAge=17, PAge)

and this seems to give me the result that I want.

Please respond if you have any better ideas