Set Expression

[VishalWaghole]

Hi Community,

I have one pivot table with 3 expression

1. sum(amount)

2. sum(amount1)

3. sum(amount)/sum(amount1)

and at the bottom line i have Total of all this columns.

My sum(amount) and sum(amount1) giving me correct Total but

My sum(amount)/sum(amount1) total giving me incorrect total coz of my set expression.

so how can we develope set expression those giving me columns total.

Thanks.

[#2]

sum(amount/amount1)

[#3]

also try this

sum(sum(amount)/sum(amount1))

[VishalWaghole]

i have already tried this but that was not giving me row level output.

Means if i have amount as 100 and amount1 as 25 then 3rd column gives me 4.

Thanks for reply

[VishalWaghole]

Thanks vishwaranjan.

I tried this but that was given me output as null values.

[MayilVahanan]

Hi

Try like this

= Column(1)/Column(2)

Hope that helps

[VishalWaghole]

= Column(1)/Column(2)

that gives me row level output but at the bottom i want Total of that Column

Thanks

[#8]

ok try this

sum(total amount/  amount1)

[MayilVahanan]

HI

can u post a sample file? with ur expecting answer?

[VishalWaghole]

PFA.

see my last expression column.

i want only Total at Bottom.

Thanks