Unfortunately I can't open your file as I'm only running 9.0
1 of 1 people found this helpful
Hi Joe - you're very close. The only issue is that you've fixed your LOD calc at the Order Date/Category level. This makes a lot of sense, but you need to be aware of what you are telling Tableau to do. In this case, you are telling Tableau to compute the number at the UNIQUE Order Date/Category intersection. That is the intersection of every unique date in the data and every unique category. To clarify, this is going to be computed at the day level, not the month level which is being shown in your visualization.
To make these 2 match, try creating a Month Truncated Order Date calculation:
DATETRUNC('month', [Order Date])
Now just replace [Order Date] in your LoD calculation with [Month Truncated Order Date], and the lines should match.
Thanks you Ben!