Forum Discussion

rmcgrath's avatar
rmcgrath
Advocate II
1 year ago
Solved

Need help with multiple columns

I am really struggling with how to tackle this:  I have a data set that has a "total dozens" column.  And then there are several columns for different sizes of product, which add up to the "total doz...
Need Help
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    1 year ago

    Hi rmcgrath ,

     

    Looking at the sample what you need to do is to unpivot the data but delete the total dozen cplumns because that is the cause of your doubling of the quantities when you sim them.

MFelix's avatar
MFelix
Super User
1 year ago

Hi rmcgrath ,

 

Looking at the sample what you need to do is to unpivot the data but delete the total dozen cplumns because that is the cause of your doubling of the quantities when you sim them.