filter pivot table

[andrew001]

hi

I'd like to create a pivot table and show only the alphanumeric ID  (indipendent by tha selection)

Thanks

tab1:
load *

inline
[ID
012
012
012
014
014
016
018
018

AAA,

BBB]

;

[Gysbert_Wassenaar]

Try a calculated dimension if(not isnum(ID), ID) and check Suppress When Value Is Null

[andrew001]

thanks but I'd like to use set analisys, so the result will be indipendent by selection

I've tried but, at now, I haven't found the solution

[simondachstr]

Try creating a dynamic dimension like this:

=aggr(Only(ID), ID))

Then you should be able to use set analysis with the function Only displaying your desired values.

In your case I think the following would to the job:

=aggr(Only({$<ID={"*"}-{">0"}>} ID), ID)