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%
hi,
Could u please attch ur XML of the report.so that we can undrestand easily.