Crosstab help

[lkcsam]

HI, I'm trying to create a crosstab (I'm a total newbie). 
I created several queries to get to the data I want. The final query contains the info and calculated measure I want to report.  My problem is that when I put a calculated measure in the crosstab it either errors or it is blank. I've been fiddling with Aggregate and Rollup functions with no luck. See example below.  I'm not working off a cube.  Any help is appreciated. 

Query Z
Month/Year
Plan Name
Count Claims
Count A Claims
Count V Claims
Count Z Claims
Measure 1 formula (Count Claims/Count Z Claims)

Example:  1st Crosstab (with Measure 1 as %)

                    PlanX        PlanY       Plan Z
Month/Year      20%         10%        3%

[Manic]

hi,

Could u please attch ur XML of the report.so that we can undrestand easily.