how to show selected values in dimensions

[venkat1]

i have a pivot table,under field po number i have different values,but in table i want to show values only starting with 'A'.
 p.f.a

[tresesco · Accepted solution]

You can use calculated dimension, like: =If(Wildmatch([Po Number], 'A*'), [PO Number])

[naddasandeep]

use below expression

=if(WildMatch(Colname,'A*'), Colname)