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.
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.