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!