sum of all above rows in the column

[#1]

Hi all,

I want to have sum of all the above rows in a column(4)

my column(4) value is dreived from column (2)* column(3)

i tried rangesum and above but in vain.

Can someone urgently help on this issue.

Regards,

Sachin.

[#2]

sum(column2*column3+columne2+column3)

isn't working?

[IAMDV]

Please can you post the sample QV document? It helps the forum users to answer quickly...

[rbecher]

You should try above( ) function. See online help.

- Ralf

[#5]

Hi All ,

Please find the attached Sample QVW.

The thing am trying is in Pivot table named MAIN and expression is New Amount.

Regards,

Sachin

[#6]

Hello Sachin,

I am not quite sure if it is exactly what you need, but it is worth a try. Create a new expression called "ThisCol" similar to this:

rangesum([Rate] * [Value], Above([ThisCol]))

[llauses243]

Hi sachin,

This is my offer ... see image & .rar (*Original.qvw)

Good luck, Luis

[#8]

Hi llauses,

Thank you very much for the reply.

I think the total of the expression that u have proposed is not sum of above all the rows.

Please find the attached doc. i have mentioned my doubts.

Regards,

Sachin

[gauravkhare]

Hi SAchin,

try it out- Go to presentation tab- there you will find two radio buttons stating---sub totals on the top and the other one showing sub totals at the bottom...choose from any one those two radios and you will be getting the desired result.

Regards

Gaurav

[gauravkhare]

Hi Sachin,

How are you taking out the sum of the above values/rows???

Are you using any sort of expressions or what..try out what I suggested and check- suppress where the value is null checkbox!