Hi J-P (Jean-Paul i guess :-),
This is the moving window table calculation
that complicates matters a lot.
Grouping (Binning) the results of table calculation(s)
should be done via table calculation(s). This is by definition.
Summing up moving LTM Sales is another table calc
on top of (table calc) bins. So it quickly becomes complicated.
And of course Customer Name should be on Detail --
this is required for the table calculations to take place.
And it also causes the stacked Marks on a view,
so one should turn them OFF to get a proper table layout.
Please find the attached.
Hope it could help.
Sample Tableau Workbook_YF.twbx 76.7 KB
This would be because of the presence
of other Dimension Pills on a view.
There are only [Customer Name] and [Date] dims
on the Sheet 7 of the Sample Tableau Workbook.
But there may be other dim pills on your original view as well.
Stacking Marks OFF place Text Marks on top of each other,
thus making text look bold & jaggy.
Perfect, thanks for the explanation!