Filter on a pivot table

[#1]

Hi Guys,

Need some help. I have the following expression in the pivot table :

({$<VendorNo={'1.....'}, KSTAR%={'.......'},Project={"S17*"}, PostingYear={'2014'}>}Cost)

However within the table i cant filter on any individual Project. I have a set analysis, which only shows projects which begin with S17, however i cant filter on a individual one.

Any ideas?

[ashfaq_haseeb]

Hi,

If it is number no need to enclose in ''

Ex

PostingYear={2014}

Will work

Regards

ASHFAQ

[#3]

Hi Naheem,

Maybe you could try "+=" after Project instead of "=".  You will have red underline syntax error but it is a bug on syntax check.

If you put += that means that it will show what is selected plus your selection in set analysis. :

({$<VendorNo={'1.....'}, KSTAR%={'.......'},Project+={"S17*"}, PostingYear={'2014'}>}Cost)

Patrick

[israrkhan]

because you have fixed projects in the set analysis.

if you wana filter, you wana see for selected project than remove it from expression.

try like ({$<VendorNo={'1.....'}, KSTAR%={'.......'}, PostingYear={'2014'}>}Cost)

and please increase your font size in next posts, its very diffucult to read such a small font and type.

Hope it Helps....

or can you please attach the sample doc...

[#5]

Hi Patrick,

Just tried that however that brings in all other projects not beginning with S17 in the table, which i dont want im afraid....

Nas

[#6]

hi,

Thank you for this. The only issue is i dont want other projects in the table. Only those projects that begin with S17. However if i do this, i cant filter on individual project in the pivot table

[giakoum]

Do you have a project name and a project id?

[jonathandienst · Accepted solution]

Hi

As I understand it, you want the chart to display all projects starting with S17, end then be able to select one project that starts with S17. I think you need an intersection rather than a union (see the asterisk below)

({$<VendorNo={'1.....'}, KSTAR%={'.......'},Project*={"S17*"}, PostingYear={'2014'}>}Cost)

However, be aware that this will exclude everything if you manually select a project that does not start with S17, because there will be no values in the intersection. You may want to use a conditional show or calculation and/or a popup warning to advise the user when this happens.

HTH

Jonathan

[#9]

PERFECT!!

Thats worked like magic! Thanks Jonathan

Nas