substringcount(Concat( - present multiple records , how to present the exact value i picked?

[shahafei2]

Hi all,

I tried to set a dynamic report

i created two inline tables _Dimensions and _Measures

_Dimensions table contain the following values

Group
A_Group

B_Group

i set a condition on each =SubStringCount(Concat(_Dimensions, '|'), 'X')

when X =  Group/A_Group/B_Group respectively

but when i pick A_Group or/and B_Group the  Group is also shown 

how could i pick the exact value that i picked instead of *Group* values

[Anil_Babu_Samineni]

Where are you trying this? Are you trying in Text box, IF so based on condition what are you expecting to see from Dimension table?

[shahafei2]

i created a dynamic report with straight table object 

and the user should pick the required fields base on two list box

_Dimensions

 _Measures

When the _Dimensions values are fields under the Dimensions tab in the straight table object  (Contains the conditions

=SubStringCount(Concat(_Dimensions, '|'), 'X') )  

and  the  _Measures values are used for the expression with the same conditions

(=SubStringCount(Concat(_Measures, '|'), 'Y'))

as i wrote the problem is that when i pick one of the "*_Group" values the condition is picking the "Group" field as well

[Anil_Babu_Samineni]

 Not sure, Still i understand the problem. Are you working for AD-hoc report? If so, Kindly post your sample application.

[shahafei2 · Accepted solution]

Thank you,

I didn't know that its called  AD-hoc report

I found the problem in the syntax

i wrote 

=SubStringCount(Concat(_Dimensions, '|'), 'Group')

instead of

=SubStringCount('|' & Concat(distinct _Dimensions, '|') & '|', '|Group|')

[Anil_Babu_Samineni]

Cool, You got the work around. Please close this thread, If you resolve by your self flagging "Correct Answer" from your Answer.