Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
The syntax should be:
sum( {$<AcNo= {“>4000<9998”},VoDt= {“>20130101<20130320”}>} AcAm)
Hi Gunnar
Try this
sum ({<AcNo = {'>4000 and <9998'}, VoDt={'>20130101 and <20130320'} >} AcAm)
regards
christian
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
Hi,
The syntax should be:
sum( {$<AcNo= {“>4000<9998”},VoDt= {“>20130101<20130320”}>} AcAm)
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