COLUMN.PARENT
COLUMN.PARENT refers to the column's immediate parent in a column hierarchy. Chaining is possible - COLUMN.PARENT.PARENT refers to the grandparent and so on.
Example
We want to calculate the percentage sales contribution from January to the first quarter.
One way to calculate would be to select the 'Units Sold' column of January and divide it by the 'Units Sold' column under Qtr1.
Instead, we can use the reference 'COLUMN.PARENT' to refer to Qtr1 as it is the immediate parent of January. In the below image, you can see that for January in the Canada region, % Contribution is calculated as 14.26/34.43 resulting in 41.40%.
You can calculate the % sales contribution from January to the entire year using COLUMN.PARENT.PARENT.
Last updated