Target file ready for data modelling

Copper Contributor

I have a monthly target file which contains,
brand wise target and customer wise target. I have file in following order.

customer Name Brand total_target january_target february_target ... 
Customer_A Brand A   100000   5000

Customer_A Brand B   120000   2000


How can I change my target file so that I can model this target to the transaction table

thank you!

0 Replies