parameter for pivot

[Anonymous]

hi,

i made in pivot an expression like this :

count(fullorder)

and i want that the users will type number (anywhwre) , and the pivot will show only the data with the same number on that exp.

is it possibele ?

hope it's clear.

thanks'

yarin.

[er_mohit]

create a variable press ctrl + alt + v then add a variable

Vcount

and in expression side write

if(count(fullorder)=Vcount,count(fullorder))

if you want that your field fullorder with same of variable then try this expression

if(fullorder=Vcount,fullorder)

hope it helps

[Anonymous]

hi,

thanks' but my goal is that the users will write number in Vcount, and the data that   show will be only with the same value that the usre type.

my exp. go like this:

if(count({$<_Flag={ord,InvAdel},[linests]={'ok'},[lineready]={'not'}>} [ordline])=Vcount,

count({$<_Flag={ord,InvAdel},[linests]={'ok'},[lineready]={'not'}>} [ordline]))

the column apear o.k but i want to show only the line in the pivot with the same values in that column and the Vcount.

is it possible ?

hope it's clear.

thanks'

yarin.

[er_mohit]

ok then try this way

if(Vcount=count({$<_Flag={ord,InvAdel},[linests]={'ok'},[lineready]={'not'}>} [ordline]),

count({$<_Flag={ord,InvAdel},[linests]={'ok'},[lineready]={'not'}>} [ordline]),null())