6 Replies Latest reply: Dec 17, 2014 12:12 PM by Robyn Talley RSS

    Dimension Calculation

      I attached a QVW that contains my test data. 


      I want to crate a straight table that tells me how many employees had X number of sales over a date range (weeks).  Example of table below...


      Sale Count     Employee Count     AVG Sale Total

      1                    21                         $35

      2                    18                         $28

      3                    19                         $34   

      4                    15                        $25

      5+                  10                         #16



      I have a unique key for each transaction/Sale.  I believe I need to create a calculated dimension using that unique sale key.


      Any help would greatly be appreciated.


      Thanks in advance.