I made a pivot table where I want to see total sales of item1 for all users in industry x.
The problem is that I want to see all userid:s that I have chosen from Table 1, no matter which Sales I choose (item1 or item2).
What happens in pivot is that If Table 1:s userid doesnt have any sales on item1, then he is not in the final list. So id need pivot to show null values for those users that dont have sales in item 1 but who are in Table 1 selection just like in excel.
I need to do this in the app so the solution is not to do joins in data load phase.