Calculate difference between season pricing for different products

[robshiffer]

I'm looking to calculate the season over season price differences for multiple different products. Currently my data is structured like this although with many more products and a longer date series. Is there a way to do this besides filtering for each different product and using a multi row formula? I currently filtered on end of season and sorted by date but then I ran into the product issue when trying to use multi row formulas

Product	Month	Season	start/mid/end	Price	Volume
A	12/1/16	Spring	End	12	40
A	1/1/17	Summer	Start	14	50
A	2/1/17	Summer	Mid	13	40
A	3/1/17	Summer	End	15	50
B	12/1/16	Spring	End	60	3
B	1/1/17	Summer	Start	55	4
B	2/1/17	Summer	Mid	57	8
B	3/1/17	Summer	End	62	1

[BenMoss · Accepted solution]

Hi Rob,

I think you are missing the group by criteria on your multirow.

Example solution attached.

Ben

[CharlieS]

@robshiffer

The Multi-Row Formula tool has a Group By function that will be crucial to achieving your desired result. I have attached an example solution.

EDIT: I was too slow for @BenMoss again.