IF(
[Quarter number]>1
,
(SUBSET_SUM([Value], SUBSET3([Product],[Year],[Quarter number]))

SUBSET_SUM([Value], SUBSET3([Product],[Year],[Quarter number],[Product],[Year],[Quarter number]1))
)
/
SUBSET_SUM([Value], SUBSET3([Product],[Year],[Quarter number],[Product],[Year],[Quarter number]1))
,
null)
SUBSET_SUM([Value], SUBSET3([Product],[Year],[Quarter number]))
/
SUBSET_SUM([Value], SUBSET2([Year],[Quarter number]))
DashboardQoQ.JPG  118K  
YoYQoQdifferences.iok  21K 
It looks like you're new here. If you want to get involved, click one of these buttons!