Expression help

[danielnevitt]

Hi,

It would be much appreciated if someone could help with the following.

I am trying to restrict a straight table/pivot table to only show pairs of information.  For example:

Field 1          Field 2

QuoteA         QuoteB

QuoteA         QuoteC

QuoteA         QuoteD

QuoteB         QuoteA

QuoteB         QuoteC

QuoteB         QuoteD

Using the above example, I would like to only see where Field 1 is QuoteA and Field 2 is QuoteB OR where Field 1 is QuoteB and Field 2 is QuoteA.

Thanks for your help.

Regards,

Daniel

[#2]

Daniel,

try this set analysis:

sum(${<Field1={"QuoteA"}, Field2={"QuoteB"}>+<Field1={"QuoteB"}, Field2={"QuoteA"}>}, Sales)

where <set1>+<set2>, the + meaning OR

Fabrice

[MayilVahanan]

Hi

Try like this

sum({<Field1={"QuoteA"}, Field2={"QuoteB"}>+<Field1={"QuoteB"}, Field2={"QuoteA"}>}Sales)

I would like to only see where Field 1 is QuoteA and Field 2 is QuoteB :

sum({<Field1={"QuoteA"}, Field2={"QuoteB"}>} Sales)

Field 1 is QuoteB and Field 2 is QuoteA:

sum({<Field1={"QuoteB"}, Field2={"QuoteA"}>}Sales)

[Jason_Michaelides]

First question - Are Field 1 and Field 2 in the same table?  If so, I would put something in the script like:

IF(

     (Field1 = 'Quote A' AND Field2 = 'Quote B') OR

     (Field1 = 'Quote B' AND Field2 = 'Quote A')

     ,1,0)                                                                 AS     ShowFlag

Then, in your chart have an expression like:

     Sum(Sales*ShowFlag)

You could create multiple different flags this way if there were other variations you require...

If they are not in the same table then the above set analysis solutions are probably best.