Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please see the attached QV application
Reagrds
Mhatim
Sorry but that's not what I was looking for.
I know how to have two axes, one on the left and one on the right.
I want the rounded sales amount on the x-axis with a bar for each amount (not for each employee) and then the height of the bar to reflect the count of employees
Not sure if this helps.
Please see the attached QV application