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

# 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

• ###### Re: Using a calculated dimension...

Please see the attached QV application

Reagrds

Mhatim

• ###### Re: Using a calculated dimension...

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

• ###### Re: Using a calculated dimension...

Not sure if this helps.

Please see the attached QV application