hi,have doute in pivot table(Enable condition)in dimension tab

[vignesh_s]

Dimension:

LOAD * INLINE [

    _Dimention

    ProductName

    ProductID

    Office

    OfficeCity

    OfficePhone

    OfficeCountry

];

and i have a productName in Product Table too,i created a pivot table with dimentions as ProductNAme ,Office etc and given expression as below,

=SubStringCount(Concat(_Dimention,'|'),'ProductName')

can any expalin how that expression working

[Anil_Babu_Samineni]

Let's talk with inline

_Dimension is the field which contains A, B, C, D ??

So, Concat(_Dimension, '|') -- Will return A|B|C|D

From here, We are going to use

SubStringCount(concat(_Dimension, '|'), 'C') -- Which contains one as Count

[omkarvamsi · Accepted solution]

i guess you are asking about adhoc reporting.

=SubStringCount(Concat(_Dimention,'|'),'ProductName')

concat will create a string with delimter '|'.

for example: A|B|C|D|E|F|B

substring will return count of the word/letter you mentioned in substring count

in mentioned example if we write as substringcount('A|B|C|D|E|F|B','B')

the above will return 2 as B is repeating two times.

in your example the substringcount(concat()) will retune 1 as ProductName is repeated once in the _Dimension.

as it returns one,the conditon enable and become true.

so when even you click on _Dimension the count shows 1 and condition will enable and chart will display respective selection.

Hope it helps you.

Regards

Om

[vignesh_s]

Thank you so much ,it held me a lot

[omkarvamsi]

you are welcome Vignesh