I did some scripting and set analysis in my table.
My question is the kpi number is wrong when I filter the 'Year' and 'Period'.
However the kpi number is correct when i filter 'YearPeriod'.
Any ideas to fix this?
I would really prefer to put only 'Year' and 'Period' in the filter pane instead of 'YearPeriod'.
Please find attached my data and scripting. Thanks for the help.
Excel TableSriptingVariables 2Variables 1Set Analysis for Total New OrderSet Analysis for Compare Last MonthThe outcome when i filter 'YearPeriod' (Correct)The outcome when i filter 'Year' and 'Period' (Wrong)