How to assign the most recent cluster to historical data
Hi,
I have this problem.
I would like to assign to Customers their most recent Cluster (based on a calendar selection) and made calculation on their historical values, disregarding their previous cluster.
In attached a simple example for one Customer.
My aim is create a bar chart with Cluster as Dimension and Sum(qta actual)/Sum(qta prevoius) as expression (where actual means selected dates and prevoius means the corresponding dates of previous year).
