Selective Expression problem

[#1]

The standard procedure of implementing selective expressions in a pivot table presents a problem beyond 9 lines in the metrics table. the SubStringCount(Concat(%metric, '|'), 10) method evaluates true for line 1 as well and both expressions are selected.

Is there a way to solve this?

[JonnyPoole · Accepted solution]

If you want to support up to 999 , use 001, 002,003 ... 999

If you want to support up to 9999 , use  0001,0002,0003,0004  ....9999

The difference is the leading zeros. Don't use 1,2,3...

ps: don't put 9999 columns in a table

[yduval75]

=count({$ * <[%metric]={10}>} [%metric]) = 1

or

count({<[_%metric]*={10}>} [%metric]) = 1

The second is more effcient