I need to develop a table that will show new and lost customers as a dimension, with multiple expressions in the columns. New customers are those that have purchased in the current year (or selected period), and lost customers are those that purchased in the same period last year but not this year.
I have the correct set analysis expressions to get the volume for new and lost customers, for example, but the users would like to add some other indicators. Instead of having two columns for each indicator (new and lost) I'd like to create a dimension with "new customers" and "lost customers".
Something that might look a bit like this :
Is it possible to add a calculated dimension for this ? I haven't found anything like this in the multitude of posts on new/lost customers!
My expression for new client volume looks like this :