How to sum a raw based on selection of another field

[#1]

Hi

I have a pivot table i want to sum (AcAm) with filter AcNo >4000 and AcNo <9998 and VoDt >20130101 and VoDt < 20130320

(Sum field AcAm (ammount) where AcNo (AccontNo) is between 4000 - 9998 and VoDt (Dato) is bestween 20130101 - 20130320

Can someone help with syntax and is it possible to it this way?

Gunnar

[#2]

Hi Gunnar

Try this

sum ({<AcNo = {'>4000 and <9998'}, VoDt={'>20130101 and <20130320'} >} AcAm)

regards

christian

[#3]

Yess it works, Christian!

Do you know how to create a new raw(C) for calculating raw (A) + raw (B) in the same pivot table to?

Gunnar

[Anonymous · Accepted solution]

Hi,

The syntax should be:

sum( {$<AcNo= {“>4000<9998”},VoDt= {“>20130101<20130320”}>} AcAm)

[#5]

Gunnar

i'm not sure to understand very well what you mean.

You can use above(field) + field  which will sum field + field from line above.

But the best is you post an example of what you want

Chris