Dear All,
I am using Sample Superstore dataset and created 3 Calculation Fields.
1- Previous_month
2- Prior_month
3- %chg
Created 2 worksheets
1- KPI_table (Showing values in Table)
2- KPI in Title (Showing values in Worksheet title )
The problem is that %chg is showing value in KPI_Table worksheet but showing "None" in other worksheet.
Tableau packages workbook is attached for better understanding.
Best Reagrds,
Muhammad Arslan
Hi @Muhammad Arslan Akram
The reason is that in your "KPI in title" you are using a further dimension, namely the Month or Order Date. If you put your calculations on Label, you can see that the previous month is calculated for November and prior month for October.
Which is why you get null as a result on your %change because your values never meet each other.
Solution
Use EXCLUDE LOD:
{exclude DATETRUNC('month', [Order Date]): [%chg]}
Remember to adjust your KPI in your header to this exclude lod and all will be fine:
if this helps in resolving your question, kindly mark as "select as best" to close the question.
Kind regards
Steffen
