I’m working on a sale’s analysis in which it’s crucial to identify which customers have ceased buying or have bought less than last year. Basically identifying our sales loss
I’m looking for 2 things here:
First, a table that ONLY shows those customers in which 2012 sales are larger than 2013 sales. In other words the Customer validation must be done using the total sum of the months selected. This must be dynamic in the sense that said customers might change depending on month selection. (In this example those whose Total sum is negative should appear on the final table, even if an individual month has a positive value). See example for more details.
The second point I’m looking for is create a button that applies a Pareto and selects only those customers who represent 80% of my sales loses.
Any help or insight would be greatly appreciated.