Forum Discussion
Solved
Unpivot and 'sum' issues
I have a data source that has 12 columns for the year (Jan - Dec). The only way I see to run the model correctly is to unpivot the 12 columns and assign Jan - Dec a value of 1-12 (or rename and chang...
Hi PBInonpro ,
You could use group by to sum them up.
After unpivotted, you get this.
Right-click the Attribute column, select Group By...
Set up as follows and then click OK.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PBInonpro Why is the total sum 10x what it should be? You can still slice by month, ideally using a dimDate table https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html
You're definitely on the right track with the unpivot.
Thanks, I think this is the solution but is there a way to visualize this? I am not quite 100% grasping why the DIMDATE matters.
