This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm so very new to the alteryx world, so please forgive me for what I am sure is a stupid question.
I'm trying to replicate a report I used to produce in a different reporting tool which features multiple variables in a crosstab format.
My data is set up sort of like this:
I feel confident there is a way to do this in Alteryx, but I've only been able to figure out how to show one variable for each day (either Pounds or Scrap, but not both). I'm also not sure the best way to introduce my % calculation. Should I add the formula into my original data or somehow bring it in later? There is an indeterminate number of "Material #s" if that makes a difference.
(If I am putting this question in the wrong place, please let me know that as well!)