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.

[VishalWaghole]

Hi

I tried this but that returns zeros.

Thanks

[er_mohit]

ok try this expression

if(Dimensionality()=1,(sum(TOTAL amount)/sum(TOTAL amount1))

or if you want Total On every Row then try this simply

sum({1} amount)/sum({1} amount1)