Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
Probably an easy one, but I can't figure out ...
In my Sales application I've got two different fields for Sales representative:
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
Ah,
istead the second one try:
=Sum({$<HistoricSalesRep={"=HistoricSalesRep=CurrentSalesRep"}>} HistoricSales)
Create a chart with:
dimension: CurrentSalesRep
expression1: Sum(CurrentSales)
expression2: Sum({$<HistoricSalesRep=P(CurrentSalesRep)>} HistoricSales)
Hey whiteline,
thx for you suggestion. Unfortunately both expressions return the same values ...
Ah,
istead the second one try:
=Sum({$<HistoricSalesRep={"=HistoricSalesRep=CurrentSalesRep"}>} HistoricSales)
Whiteline,
thanks a lot! I don't really understand that set analysis expression, but it works
Regards,
Florian