1. I want to create a flagging dimension that could be use to make the customers disappear from the table, i.e. if there are 6 consecutive months of sales or no sales for 6 months, return null, otherwise return customer name, and hide null value.
2. I want to display the sales of last 2 months and 13-24 months ago without the use of autocalender just by order date.
