How to group measures by dimensions

[pupmup]

Hello,

I have a sample data set like the below. 

Sometimes, retailers announce sales before the official release date of a product.

I need to group up all the pre-release sales of a product in the database and include them in the release week entry.

Retailer	Product	Product Release Date	Current date	Sales
A	A	X	Z-1  Week	10
A	A	X	Z	5
A	A	X	Z + 1 Week	5

End result :

A / A / Z - 15 sales

A / A / Z+1 - 5 sales

[danrh · Accepted solution]

Something like this?

This assumes that your Product Release Date and Current Date fields are both already Date data types.  If not, you'll need to change them first.

Hope it helps!