Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Hi,
If it is number no need to enclose in ''
Ex
PostingYear={2014}
Will work
Regards
ASHFAQ
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
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...
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
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
Do you have a project name and a project id?
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
PERFECT!!
Thats worked like magic! Thanks Jonathan
Nas