Hello Qlik Community,
I am looking to understand more on the behaviours of Pivot Table:
- My Pivot Table is built with two dimensions(One parent to many children with many parents) and measure is defined with the formula of Count(child). In addition to this, I also used Pivot Table’s background colour expression to determine the colour for both dimensions. Is the parent’s background colour a summation (or roll up) of the children’s background colour expression ignoring the parent’s background colour expression?
- If yes, how can we prevent the parent dimension’s summation calculation from happening?
Please refer to the picture below for better illustration. Thanks, in advance, for your time and effort in helping!
![Screenshot 2020-11-05 153531.jpg Screenshot 2020-11-05 153531.jpg](/t5/image/serverpage/image-id/43574iE32C1CC3E6813693/image-size/large?v=v2&px=999)