-
Re: Intersection
try this
Aggr(Count( {$<Field= {'Value1', 'Value2'}>} Dim1), Dim2)
or
=count (distinct {<code = P ({<exam={"1"}>} code ) >*<code = P ({<exam={"2"}>} code ) > } code )
-
-
Re: Intersection
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
-
-
-
Re: Intersection
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) >}
-
Re: Intersection
both the fields are same in two filter panes after selections in both the filter panes I want intersection rather than union.
-
Re: Intersection
you can't achieve it using only one field, you need to create two extra fields in your script as I wrote before.
-
-