Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can use calculated dimension, like: =If(Wildmatch([Po Number], 'A*'), [PO Number])
You can use calculated dimension, like: =If(Wildmatch([Po Number], 'A*'), [PO Number])
use below expression
=if(WildMatch(Colname,'A*'), Colname)