crosstab calculations

[charon]

Hi cognoisers,

sad but true: im still not capable to get al calculations of cognos that i want :S

Following scenario: Crosstab with several facts as rows and columns with created data items for YTD, YTD-LY based on prompts for current year and month AND Columns for Percentage Calculations.

                    YTD               Ratio YTD              YTD-LY           Ratio YTD_LY
fact 1
fact 2
fact 3
fact 4

The challenge (for me ;): Ratio is calculated for every row, and the calculation is YTD (every row) against FACT1 (always against fact1)
so FACT 2(YTD) / FACT1(YTD)
    FACT 3(YTD) / Fact 1 (YTD)
    FACT 4 (YTD) / FACT 1 (YTD)

Ive tried sth _: creating a data item with 'curretn_measure within detail / fact1', set the aggregation to 'calculated'... is that the correct way?
Or are there other functions? ive searched the ibm documentation for RS functions, but didnt find it :S

Any ideas are appreciated, thx a lot and ..have a nice weekend (or IOD if youre there ;)
cheerz :P

[Bark]

Is it a cube? If so:

[YTD] = aggregate(currentMeasure within set [setOfMonths]) <-- [setOfMonths] are the members of your year to date.
[YTD_Ratio] = aggregate(currentMeasure within set [setOfMonths]) / aggregate(currentMeasure within set [setOfMonths],[FACT1]) <-- where [FACT1] is the member from the cube.

Regards,

Bark

[charon]

ty sir for replying :)