Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|Company|')
how it works can anybody explain me
HI
Concat(distinct dimension, '|') - gives the unique dimensions concatenate by pipe symbol.
SubstringCount() - gives the number of occurrance of substring matches in the string.