Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
please post some sample data and your expected result
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)))))