Hello i have the following table :
acc ID col1 col2 col3 TOTAL_WO
after aggregating on 'acc' i get the follwoing table:
acc col1 col2 col3 TOTAL_WO
but i want to get the following :
acc col1 col2 col3 TOTAL_WO_cc TOTAL_WO_ss1
which is keeping the details of TOTAL_WO for the columns SS and CC .
any help please?
thank you .
Solved! Go to Solution.