Forum Discussion

rmcgrath's avatar
rmcgrath
Icon for Advocate III rankAdvocate III
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.

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

If you excluded total dozens from the total and add a slicer, shouldnt that give you  to correct total? Also, I don't think a line chart is the correct one for this.