Greetings to the community!
I struggle with the following Pivot table behavior:
Screenshot 101: Order Month-Project-Product, the TOTAL<Month> gives me the right values;
Screenshot 102: Order Product-Month-Project, the TOTAL<Month> gives the right values when all the levels are open,
Screenshot 103: same order, but when I close one of the drills (part. 'Door'), I get wrong total values.
What is wrong here - either it's me and a lack of understanding of Qlik features or is it a bug?
I've attached the the app with this table.
I want to get the 101 and 102 slide TOTAL <Month> disregarding the selections and drill-down states, like the ones I get in Screenshot 101 and 102, so basically it should show me the total costs per month in any of view combinations.
It would be the total cost of specific product per month.