SubStringCount Advanced

[brunopaulo]

Hi community,

I can't solve this problem and would be great if you could help me.

At the moment i have 4 tables each one has Dim1, Dim2, Metric1.
The values on this fields change based on Dim3. If dim3 has no selection, then show nothing. If Dim3 has 1 selected i want to show the results for that selection, if 2 values of dim3 are selected then show me the correct values. And the perfection is if dim3 has 2 value selected i could represent all in metric1 column.

Any help would be great. Thank you in advance

Best Regards

Bruno Paulo

[MarcoWedel]

please post some sample data and your expected result

[Anil_Babu_Samineni]

This is my assumption?

If(GetSelectedCount(Dim3)=0, '',

If(GetSelectedCount(Dim3)=1, Sum(Metric1),

If(GetSelectedCount(Dim3)>2, Sum({<Dim3=P(Dim3)>} Metric1),

If(GetSelectedCount(Dim3)=2, Sum({<Dim3=>} Metric1)))))