Pivot table calculated measure behavior when drilling down into date column

[alandilworth]

Hi, I have a pivot table shown below that displays sales metrics across different entities across time.    I have a 'Year' and 'Quarter' column that you can drill down into.  When on the 'Year' level the '% Change' measure calculates the change in 'WAC' from the current year to the previous.  When drilled down into the 'Quarter' level the '% Change' measure calculates the change in 'WAC' from the current quarter to the previous. 

My problem is this:   When drilled down into 'Quarter' it never calculates Q1 even if a previous year exists.  The expression I am using to calculate '% Change' is below:

Sum(AllTimeMegaTotal)/Before(Sum({<[Year]>}AllTimeMegaTotal)) - 1

Any insight will be greatly appreciated!

[QFabian]

Hi @alandilworth , try using dimensionality() function, to maybe change the formula depending of the dimension level

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inter...

[alandilworth]

Unfortunately dimensionality() will not work since I have rows  and columns with multiple dimension levels.  Is there a function similar to dimensionality() that will only return column dimension results?