Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a problem that is I have two filter panes with the same dimensions, If I select a value in the first filter pane and another value in the other filter pane, I want the result to be as the intersection of both the values selected rather than the union.
regards,
sai.
try this
Aggr(Count( {$<Field= {'Value1', 'Value2'}>} Dim1), Dim2)
or
=count (distinct {<code = P ({<exam={"1"}>} code ) >*<code = P ({<exam={"2"}>} code ) > } code )
can u please elaborate the syntax what u have written thats not working
maybe this:
Suppose you have two fields (DimField1, DimField2) in your data model related to the same database field (DimField).
ex.
{< DimField = P(DimField1) * P(DimField2) >}
both the fields are same in two filter panes after selections in both the filter panes I want intersection rather than union.
you can't achieve it using only one field, you need to create two extra fields in your script as I wrote before.
hi chanty,
What you wrote is fine but, Instead of count I need the code values . How can I achieve it.
Thanks in Advance,
Sai
maybe this:
Concat( {< DimField = P(DimField1) * P(DimField2) >} code, ';' )
Its not Working