3 Replies Latest reply: Oct 10, 2012 6:44 AM by mhatim2012 RSS

    Using a calculated dimension...

      This is the first question I have posted so hopefully I can make it clear.


      I have one big table of individual sales, with amongst other things, value of sale and the EmplyeeNo of the person who made the sale.


      I want to draw a bar-chart that shows the number of employees who sold different amounts.


      So the dimension of the bar chart would be something like:


      Round to the nearest 100 ( Sum ( [for each EmployeeNo] SalesValue))


      And the expression would be:


      Count (Distinct EmployeeNo)


      ie I want to look at the distribution of total sales per employee.


      But I can't figure out how to write the dimension. I have made lots of attempts along the lines of


      Sum(Total <DISTINCT EmployeeNo> SaleAmount )


      But they all return errors...


      Any help would be much appreciated