SUM columns in ETL

I have a business request to add a dynamic goal line based on the sum of a certain series across all series.  The best way I could think to make this happen in ETL would be to create a parallel workflow that filters to the single series I want my goal based on and sum the column.  In the original workflow, it would be adding a column with a constant, then when they join back together, the contant could be replaced with the sum value of the filtered workflow. 


So basically, we have a separate series in our data for total category, and then rows for each individual category as well.  I'd like to have a per unit calculation for the total category series as the goal for all series.  That way, we can compare out performance to rest of market per series instead of just within that series. 



0 votes

· Last Updated

This discussion has been closed.