Calculations in crosstab reports

[Raghuvir]

Hi,

i have to add a calculated filed in my crosstab report.

Please find the attached image for the requirement

[adik]

just drag over a query calculation from the toolbox and type in your formula

[Raghuvir]

hi,

could you help me with the formula

[Satheesh]

Hi Raghuvir,


Calculated means how u want...???
what is calculated...??? is there any formula you applied on camping Equipment....???




May be U want to like this...
You want only Camping Equipment and Golf Equipment...... separately do the Following


In Query
Drag Data Item and write the Formula like below and Make this data item name as Camping Equipment


if([Product Line]='Camping Equipment') then
( [Qty] )
else
(0)






- Sateesh
98672 00664

[rajasekharbathala]

Hi,

create three data items
data item1 is GE as
case when [Product] = ('GE') then
([Unit cost]) else (0)
end
and data item2 is
case when [Product] in ('CE') then
([Unit cost]) else (0)
end

data item3 is GE/CE as total([GE] for [Year]) / (total([CE] for [Year]))

add GE/CE data item to the right side of the crosstab.

Regards
Bhaskar.