Cantona_lives
New Member
- Joined
- Nov 27, 2013
- Messages
- 20
Hi all,
I am starting to learn about PowerPivot and the value it can provide, but I am hitting a few roadblocks that some kind person can possibly help me with.
So I have a SQL query that pulls in 'Name', 'Task' and 'Finish Date' from an external source.
I would like to be able to have 'Week commencing' running across the pivot table columns and then 'finish date' appearing in the value of the date within which it falls.
Something like this :
Week Commencing
Name Task Finish Date 29/12/2014 | 05/01/2015 | 12/01/2015
Test1 Task 1 01/01/2015 Yes No No
Of course a number or anything in the value section would work as I am attempting to create a timeline.
I have managed to pull all the week commencing in as a table, but getting them to link other than just as a date is the challenge. In other words, I can display dates, but no values. Therefore I am missing a vital piece of the relationship.
Hope that makes some level of sense?
Thanks in advance for any advice.
-CL
I am starting to learn about PowerPivot and the value it can provide, but I am hitting a few roadblocks that some kind person can possibly help me with.
So I have a SQL query that pulls in 'Name', 'Task' and 'Finish Date' from an external source.
I would like to be able to have 'Week commencing' running across the pivot table columns and then 'finish date' appearing in the value of the date within which it falls.
Something like this :
Week Commencing
Name Task Finish Date 29/12/2014 | 05/01/2015 | 12/01/2015
Test1 Task 1 01/01/2015 Yes No No
Of course a number or anything in the value section would work as I am attempting to create a timeline.
I have managed to pull all the week commencing in as a table, but getting them to link other than just as a date is the challenge. In other words, I can display dates, but no values. Therefore I am missing a vital piece of the relationship.
Hope that makes some level of sense?
Thanks in advance for any advice.
-CL