Darkzler
New Member
- Joined
- Sep 25, 2015
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
Hello everyone,
I hope someone here can help me because right now I'm clueless on what to do.
I've attached a file with the data. From this data I need to make a pivottable where I can easily show per week and day what type of "Specialkompetens" we have available per date.
As you can see, we have the specialkompetens in column A and down. However, the date and weeknum etc are in row 2-4.
What I need to see in a pivottable is pretty much:
Week 24
The amount of specialkompetens per type, example:
- STF 2
- Allt 10
etc
Which pretty much means that we sort both by the X and Y axis. Is this possible?
FILE SOURCE: TinyUpload.com - best file hosting solution, with no limits, totaly free
Would really appriciate any help I can get from you.
Best regards,
Darkzler
I hope someone here can help me because right now I'm clueless on what to do.
I've attached a file with the data. From this data I need to make a pivottable where I can easily show per week and day what type of "Specialkompetens" we have available per date.
As you can see, we have the specialkompetens in column A and down. However, the date and weeknum etc are in row 2-4.
What I need to see in a pivottable is pretty much:
Week 24
The amount of specialkompetens per type, example:
- STF 2
- Allt 10
etc
Which pretty much means that we sort both by the X and Y axis. Is this possible?
FILE SOURCE: TinyUpload.com - best file hosting solution, with no limits, totaly free
Would really appriciate any help I can get from you.
Best regards,
Darkzler
