Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Calculate difference between season pricing for different products

robshiffer
7 - Meteor

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

 

ProductMonthSeasonstart/mid/endPriceVolume
A12/1/16SpringEnd1240
A1/1/17SummerStart14

50

A2/1/17SummerMid13

40

A3/1/17SummerEnd15

50

B12/1/16SpringEnd60

3

B1/1/17SummerStart554
B2/1/17SummerMid578
B3/1/17SummerEnd621
2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

Hi Rob,

 

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

 

Example solution attached.

 

Ben

CharlieS
17 - Castor
17 - Castor

@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.

 

MultiRow-GroupBy.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

EDIT: I was too slow for @BenMoss again. 

Labels