Group sales based on date range

[jowah37]

Hi ! 

I'm stucked with a problem I hope someone in the community can help with... 

I need to group my sales data so I know what is "Current", "Previous", "Fixed" and "Clearance". I need to base it on campaign numbers so that 2209 eg. is current and 2208 is previous, 2206 Clearance etc.  

I have a dates lookup table and the campaign codes are connected as a many-1 relationship between the sales table and product data lookup table with the SKU as the KEY. 

Hope somebody can point me in the right direction 

/Jonas

[johnt75]

Create a new dimension table for Campaigns, with Campaign Name and Campaign Code as the columns, and a sort order column if needed, with one row per Campaign Code, and then link that to your product table as one-to-many. You can then use the Campaign Name column in any visuals and that will group your sales automatically.