Comparison between 2 independant dimensions

[pennetzdorfer]

Hey,

Probably an easy one, but I can't figure out ...

In my Sales application I've got two different fields for Sales representative:

• HistoricSalesRep from Sales table
• CurrentSalesRep from Customer master table

Now I would like to compare Sales between those 2 fields. For example:

Sales Rep	Historic	Current
A	1,265	1,150
B	2,458	2,581
C	1,859	1,737
D	5,887	6,001
Total	11,469	11,469

Does anybody know how to achieve that?

Regards,

Florian

[whiteline]

Create a chart with:

dimension: CurrentSalesRep

expression1: Sum(CurrentSales)

expression2: Sum({$<HistoricSalesRep=P(CurrentSalesRep)>} HistoricSales)

[pennetzdorfer]

Hey whiteline,

thx for you suggestion. Unfortunately both expressions return the same values ...

[whiteline · Accepted solution]

Ah,

istead the second one try:

=Sum({$<HistoricSalesRep={"=HistoricSalesRep=CurrentSalesRep"}>} HistoricSales)

[pennetzdorfer]

Whiteline,

thanks a lot! I don't really understand that set analysis expression, but it works 

Regards,

Florian