0 Replies Latest reply: Feb 18, 2013 5:11 AM by Kristian König

Hello,

i have a chart that looks like this:

ID ; number of buyers (count({\$<Datum_fakture={">=\$(Datum od2) <=\$(Datum do2)"}>}DISTINCT CUSTACCOUNT)) ; (the formula i am searching for A); the 2nd one i am searching for B)

I use filters like "salesman" "Division" and "Djelatnost" to get the count by ID. To make a comparison between these values i need 2 formulas.

The first formula i need A:

There is a value "Djelatnost" by ID. I need the formula A to change the numbers ONLY if i change the "Djelatnost" filter, by changing any other filters it should remain the same.

The formula B:

Non changeable formula(all does not work because i got values sience 2009), i need the average value by the top 3 salesman by Division.

count({\$<Datum_fakture={">=\$(Datum od2) <=\$(Datum do2)"}>}DISTINCT CUSTACCOUNT) this is my formula, i would appreciate any help for solving formula A and B, please.

At the End the table should look like this:

ID     number of buyers     Djelatnost     Top 3 value by Division

1     3                              3                   2,9

Filters ON: NONE

ID     number of buyers     Djelatnost     Top 3 value by Division

1     1                              3                   2,5

Filters ON: Salesman "XY", Division "XY"

ID     number of buyers     Djelatnost     Top 3 value by Division

1     1                              1                   2,5

Filters ON: Salesman "XY", Division "XY", Djelatnost "XY"