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.