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"