We have a requirement where there is a measure along both the x-axis and y-axis. Say, Employee count and Employee Salary are measures. The Dimension is department,Department Employee Count Employee Salary 1 100 1000 2 200 2000 3 300 3000 4 400 4000
What is required is a chart where,
Employee Count should be on the y-axis. Employee salary should be on the x-axis and the Department will be in the z-axis or region colors will be by Region.
The X-axis needs to be continuos, that is the employee salary for department 1 being 1000, the employee salary for Department 2 should start after 1000 till 3000, for department 3 from 3000 to 6000. For department 4 from 6000 to 1000. The bar width should depcit the employee salary and the bar height show the Employee Count.