I have a problem with two tables. The first table contains employees in different sections per month. Only if an employee is in the specific section it is marked with a "1".
The other table contains sales per employee per month.
My problem is that employee no. 3 is not in the company in october, november and december and employee is not in the company in january and february. But for some reason some of their sales are registered in these month.
To link the two tables I have created a key with employee and month. When I create a Pivot table with numbers of employees per section per month it shows everything correct, but when I create a Pivot table with sales per employee per month it shows the sales for employee no. 3 and 4 in the months they are not in the company in a separate row and column marked "-".
Can you help me to show the sales in the correct months but in a new row below the sections with the text "Sales not correct registered"? It should also be possible to select the value "Sales not correct registered" in the Section listbox.
this is very easy, the sum 29 are employee No 4 in Jan and Feb and No 3 in Oct, Nov and Dec. You entered them a sales value but they didn't work in this months. In your pivot you can supress showing NULL-values for all three dimensions dept, employee and Month. Look at the uploaded File.
that was a good suggestion but unfortunately not the answer I was looking for. The sales must be shown in the month they are registered but with a new row created called "Sales not correct registered". If I suppress when value is Null the sales of 29 units is missed.
Below I have manually made a solution which I want QlikView to show unless there is a better way to do it.
