Using Len function in pivot table as calculated field to filter data

Hi Guys,

i have source table which i am downloading from external workbook.
I can not change the table:

What i am doing i am refreshing pivot table to get uniques list in the most efficient way.
Problem is that i have to filter Key and Key2 based on number of characters.
Perfect solution would be to add calculated field into pivot and just filter it.

But i have read that is not possible.
How to do workaround?

Writing code will be not that fast as pivot table to add calculated field...

Please help,
attachment i added.

Best,
Luke

this is awesome!!

thank you very much Bo_Ry.

Key2 is reserve for column KEY row 2

Can you please explain more ? How this is working ?

Best,
Jacek

Ok great,

i will watch it,

thanks!

Jacek