How to write expression in Pivot table

[#1]

Hi,

I need to get the values of Amount when

Amount>0 and Domain='RR' and Type in ('old',New') and ID=56432

here Amount,Domain,Type are from Sales table where ID is from Account table.

could anyone help me please how to write expression to get Amount.

Thanks.

[jcoggon]

Could you maybe explain a little more what you are trying to do or upload a sample app.

[#3]

Thanks and will the same works for Amount instead of Sum(Amount)?

[MK_QSL]

It's so simple still confusing. Could you pleas upload file ?

[thomaswrieck]

Not really clear what you would like to achieve ...

If you just want to sum up Amount matching your criteria you could use :

sum( {<Domain={'RR'}, Type={'old', 'new'}, ID={1}>} Amount)

Here, there's no need to exclude 0 amounts ...

If you just want to show data in a table matching your criteria, the only thing i could get to work is using a bookmark.

Just check the qvw ... and choose the available bookmark ...

it has been created by using a search box and entering the following :

=Amount<>0 and ID=1 and (Type='new' or Type='old') and Domain='RR'

Then hit enter and save this as a bookmark.