Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help in creating three charts. Selecting a employee name in the “employee name” list box, one chart must show their annual sales compared to the annual average sales of employees in their same position (Employee_Pto field)
Another chart shows must show selected employee annual sales compared to the annual average sales of employees in the others position (Employee_Pto field)
Last chart must show selected employee annual sales compared to the average sales of employees in their same department (for example, if I select employee 36, must show their annual sales compared to the annual average sales of employees in 5000 to 5210 department_id
I’ve attached a data model.
Any help would be appreciated
Thanks
Hi!!
On main sheet, i have a chart (salesman-avg all pto). How do I show the avg sales of all Pto excluding the position (pto) of the selected employee??
On sheet1, level 1 chart I want to show by year, the avg sales for each one of the levels but it shows the same value for each level.
Thanks for the help.
Regards
Hi,
try this :
assume Year is selected or is in dimension :
(sum({1<Employee_Pto = P({$}) >} Sales) - sum(Sales) ) / (count({1<Employee_Pto = P({$}) >} Emplye_ID) -1)
ie : sum of sales all salaries in same position - sum sales of selected salary
divide by count of salary same posityion minus 1
(replace with your field I didn't load qvw
regards
Hi Olivier!!
Thanks for your reply.
I`ve used yoru expresion in my main sheet chart (salesman-avg all pto) an the result is "allocated memory exceeded"
Regards
what are your dimensions ?
in a shart it take account of dimension but it could be necessary to add total <Employee_tpo> somewhere.
and could you share some datas
On my sheet 1 chart (Level 1) my dimensions are Year and Level 1.
On main sheet chart (salesman-avg all pto) dimension is Year.
I think all data is in attached file in my second post.
thanks!!
I have a free version, can't upload qvw
select an employe, year and try expression in list box to begin,
and in text th load inline if you have