trying to solve this question

[gayathri27]

nikita's cabinetry sells over 200,000 different finished cabinet options. The price of the cabinet is dependent on the wood, door style and finish chosen. In the dataset provided each cabinet code lists all of the information for that particular cabinet option. How many options are available for a cabinet made of maple wood between 400 and 500 dollars. how to solve this in alteryx?

[cjaneczko]

I came up with 1240. Cross tab the data, filter it, then summarize.

[binuacs]

@gayathri27 Another way of doing this

[gayathri27 · Accepted solution]

What parameters did you use in the cross tab? I am able to pivot the data like I want it. Thanks

[cjaneczko]

[Anthony_Giesing]

I got to the same answer using the attached configuration in the crosstab tool: