Lennythelucker
New Member
- Joined
- Jun 16, 2011
- Messages
- 4
I like to pivot a datatable with a lot of values per row (for each product and day) to a single row per customer.
now I make a pivot table to excel to do this, link it to a table and bring it back to powerpivot.
then I can link it to other tables due to the unique ID
see image:
this side step to excel and back is not nice and I feel there must be a better way. I like to do this inside Powerpivot. is there an option I don't know about to do this sort of moddeling?
thanks for your help!
now I make a pivot table to excel to do this, link it to a table and bring it back to powerpivot.
then I can link it to other tables due to the unique ID
see image:

this side step to excel and back is not nice and I feel there must be a better way. I like to do this inside Powerpivot. is there an option I don't know about to do this sort of moddeling?
thanks for your help!