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

    Asking for help on formula - Please

    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"