Hello Everyone,
I have the following problem:
I have a KPI which is showing this : (Sum([Sales_Invoice_Line.Amount])+Sum([Tabelle1.Amount]))
and then I created a small table, which goal is to show a ranking of different sales partners and from which of them how much they should.
The problem is not easy to explain with words, if you open the excel table, you will understand it better.
In the table I used this formulas:
aggr(rank(Sum([Sales_Invoice_Line.Amount])),[Sales_Invoice_Line.Agent Code])
=[Sales_Invoice_Line.Agent Code] (Those r the sale partners)
(Sum([Sales_Invoice_Line.Amount])+Sum([Tabelle1.Amount]))
Thanks in advance