How to show only slected data in a pivot table

[nevilledhamsiri]

Hi,

Please advise me how I could restrict the condition below.

As per data given in the pivot table  below, I need to show data only for ACCOUNT_CODE 37440, 37500,37460 & 37110 & data on other codes to be excluded from appearing in the table!

Thanks

Neville

[sunny_talwar · Accepted solution]

Use set analysis in all your expressions

{<ACCOUNT_CODE = {37440, 37500,37460, 37110}>}

[vishsaggi]

Your Question title says selected data so, you mean there is a possibility that you might select different accountCodes or only these 4 codes you mentioned?

[nevilledhamsiri]

Only four codes given