Dimenstional Hierarchy Checkbox and Passing Values to Filter

[gosoccer]

I have attached the report spec. I am trying to pass to the filter the values that are associated to each Caption of the Checkbox. I created a CSV file and brought it to Tranformer as a Datasource. Created the Cube and brought it to the Report Studio, Now, the Caption (TYPEA, TYPEB, TYPEC) are the Top Level and what I need to pass to my Query Filter are at a lower level. Any ideas what I can do to have the filter to work correctly so when the user selects TYPEA, the resulting Crosstab will only show the data for Back, Brown, Silver? Here is a sample CSV file.

TYPEA|Black
TYPEA|Brown
TYPEA|Silver
TYPEB|Brass
TYPEB|Mahogny
TYPEB|Red
TYPEC|Blue
TYPEC|Pink

here is the spec file,

[tjohnson3050]

Instead of using the caption, just use the mun.

Create a prompt using the top level of the dimension, and name the parameter 'ParameterName'.

In the crosstab, create a calculation:

descendants(?ParameterName?,1).

That will return a set that includes Black, Brown and Silver when TYPEA is chosen in the prompt.

[gosoccer]

OK, thank you,
I right clicked on the Crosstab Node (Coulmn) and selected Calculate. There is Insert Custom Calculation but not sure where to go from here or am I
totally wrong? Thx so much for your time.

[tjohnson3050]

From the tool box in the insertable objects section, there is an object named query calculation.  That is what you want to use.

[gosoccer]

I am getting an ugly error. I think it's getting close. thx so much! here is the spec on what I have. :-\
I dropped the calculationthe Crossbar column that the color type are. Let me know what you think at your
convenience.

[gosoccer]

tj,
the following works but not sending the right arguments. it's getting the TYPEA, TYPEB, TYPEC and not the children.
would the descendant be something like

descendants([sample_checkbox_amini].[Color Type].[Color Type].[Color Code],(?ParameterName?))

[tjohnson3050]

Try this instead:

descendants(?ParameterName?,1)