Forum Discussion
Count Rows where not in Previous Period
I have a visual that sums total sales for a product category over time. For each period (usually month), I would like to sum the total number of product categories that aren't in the previous period....
It's, in essence, nothing but an question of MoM comparison.
Thank you this is very helpful. I had wanted count and not concat but that's pretty easy to fix. My only issue with this is that it's not possible to group up. If I want to add quarter or year to the table, it won't work correctly on quarter or year.