Check box Department in the Pivot Table

Wednesday, 9 September 2009 10:05 by cdeschamps

What is the check box "Department" in PlanningPME used for while creating reports via Pivot Table?

From the menu Tools -> Pivot Table, you can make some precised reports and export data from PlanningPME to Excel.

You can have the number of hours worked per month per resource or have any kind of statistics on your projects, tasks and/or employees vacation.

Now, you noticed the box "Department" on the Pivot Table window.

When should you use it?

You should tick on this box when you want to make statistics on your departments and that your resources are allocated to more than one department.

Let's take an example.

In the example below, Paul and Mary are part of 2 departments: S1 and S2.

Here are the settings used for this demo:

If we do not check the box "Department" the results are not correct:

The departments are not displayed correctly.

If we check the box "Department" the results are correct:

Tags:  
Categories:   Pivot Table
Actions:   E-mail | Permalink | Comments (65) | Comment RSSRSS comment feed

Comments

November 14. 2009 14:11

Do you make money out of this blog? just curious

payday loans

November 23. 2009 18:00

Great post! I am just starting out in community management/marketing media and trying to learn how to do it well - resources like this article are incredibly helpful. As our company is based in the US, it?s all a bit new to us. The example above is something that I worry about as well, how to show your own genuine enthusiasm and share the fact that your product is useful in that case.

White Artificial Christmas Trees

November 25. 2009 17:36

Keep 'em coming... you all do such a great job at such Concepts... can't tell you how much I, for one appreciate all you do!

CORNER GAS FIREPLACE

November 26. 2009 18:21

When I originally commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment is added I get four emails with the same comment.
Is there any way you can remove me from that service?
Thanks!

Forever Marine Mask

November 27. 2009 20:41

I had some interesting opportunities and difficult decisions to make over the past few weeks and I'm really excited to join Falafel.

web based crm

November 29. 2009 13:07

You got a really useful blog I have been here reading for about an hour. I am a newbie and your success is very much an inspiration for me.

conceiving a boy

November 29. 2009 22:27

Hey - nice blog, just looking around some blogs, seems a pretty nice platform you are using. I'm currently using Wordpress for a few of my sites but looking to change one of them over to a platform similar to yours as a trial run. Anything in particular you would recommend about it?

what are the symptoms of a yeast infection

November 30. 2009 16:03

A pivot table is a data summarization tool found in data visualization programs such as spreadsheets.

Search Engine Optimization

November 30. 2009 17:36

Working as a Website Developer, web development is only one of many services..........

search engine optimisation

November 30. 2009 20:46

Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon.

Doug

December 1. 2009 17:12

cool

Gewichtsreduzierung

December 2. 2009 19:16

Couldn?t be written any better. Reading this post reminds me of my old room mate! He always kept talking about this. I will forward this article to him. Pretty sure he will have a good read. Thanks for sharing!

used car prices

December 2. 2009 20:51

Dude.. I am not much into reading, but somehow I got to read lots of articles on your blog. Its amazing how interesting it is for me to visit you very often.

Duncan Oldham

December 2. 2009 21:15

I was looking for crucial information on this subject. The information was important as I am about to launch my own portal. Thanks for providing a missing link in my business.

blues guitar improvisation

December 4. 2009 17:46

Admiring the time and effort you put into your blog and detailed information you offer! I will bookmark your blog and have my children check up here often. Thumbs up!

lord, Jesus

December 5. 2009 22:07

Thank you for another great article. Where else could anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am on the look for such information.

Outdoor Cat Houses

December 5. 2009 22:10

I was looking for crucial information on this subject. The information was important as I am about to launch my own portal. Thanks for providing a missing link in my business.

How to lose weight

December 6. 2009 04:22

You may have not intended to do so, but I think you have managed to express the state of mind that a lot of people are in. The sense of wanting to help, but not knowing how or where, is something a lot of us are going through.

low cost dental insurance

December 6. 2009 21:48

I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post

Internet Radio

December 7. 2009 01:11

I was wondering what is up with that weird gravatar??? I know 5am is early and I'm not looking my best at that hour, but I hope I don't look like this! I might however make that face if I'm asked to do 100 pushups. lol

health and safety training barrow

December 7. 2009 01:39

Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It's always nice when you can not only be informed, but also entertained! I'm sure you had fun writing this article.

teeth whitening procedure

December 7. 2009 18:58

Aw, this was a really quality post. In theory I'd like to write like this too - taking time and real effort to make a good article... but what can I say... I procrastinate alot and never seem to get something done.

softwareudvikling

December 8. 2009 05:47

The blog was absolutely fantastic! Lots of great information and inspiration, both of which we all need!

reverse mortgage california

December 8. 2009 20:35

Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with more information? It is extremely helpful for me.

online backup

December 8. 2009 21:32

Dude.. I am not much into reading, but somehow I got to read lots of articles on your blog. Its amazing how interesting it is for me to visit you very often.

How to get a girl

December 10. 2009 20:45

Nice resource. rss feed added

pay day loans

December 13. 2009 23:07

Hey - nice blog, just looking around some blogs, seems a pretty nice platform you are using. I'm currently using Wordpress for a few of my sites but looking to change one of them over to a platform similar to yours as a trial run. Anything in particular you would recommend about it?

natural dog food

December 14. 2009 20:49

The beauty of these blogging engines and CMS platforms is the lack of limitations and ease of manipulation that allows developers to implement rich content and 'skin' the site in such a way that with very little effort one would never notice what it is making the site tick all without limiting content and effectiveness.

Britt Borden Neurosurgeon

December 16. 2009 21:54

Great insights. I loved to read your article. You must be putting a lot of time into your blog!

anonymous proxy

December 18. 2009 05:57

Your post give me some idea. Thank you.

Skin care

December 18. 2009 07:34

Wow! I like this post. Thank you.

Toys

December 18. 2009 08:33

Excellent post.

Camera lense

December 18. 2009 09:28

Great post. I like it.

Digital camera

December 18. 2009 23:20

Howdy, i read your blog occasionally and i own a similar one and i was just wondering if you get a lot of spam comments? If so how do you prevent it, any plugin or anything you can advise? I get so much lately it's driving me mad so any assistance is very much appreciated.

French Dessert Recipes

December 19. 2009 04:47

Aw, this was a really quality post. In theory I'd like to write like this too - taking time and real effort to make a good article... but what can I say... I procrastinate alot and never seem to get something done.

Salsa Chicken Recipes

December 19. 2009 20:41

Hey - nice blog, just looking around some blogs, seems a pretty nice platform you are using. I'm currently using Wordpress for a few of my sites but looking to change one of them over to a platform similar to yours as a trial run. Anything in particular you would recommend about it?

contractor accountant

December 19. 2009 20:47

Well, this is my first visit to your blog! We are a group of volunteers and starting a new initiative in a community in the same niche. Your blog provided us valuable information to work on. You have done a marvellous job!

set up a company

December 21. 2009 09:44

I admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well.

usa online casinos art

December 21. 2009 10:23

I admire the valuable information you offer in your articles. I will bookmark your blog and have my children check up here often. I am quite sure they will learn lots of new stuff here than anybody else!

us online casinos

December 21. 2009 16:33

I am not much of a guy who thinks in so deeply about web design but I think your post had some valid points in it. Like designers are forced to design stuff within the limited code available and not go beyond it, their innovation is somewhat limited but still I think Web Design won't die! I agree that Amazon and other some big sites won't have a blog but now a days it's very important to have some sort of option available so people can quickly communicate their thoughts. I think Amazon if wants to shift it to that, they can get a customized CMS for themselves.

us online casinos jes

December 23. 2009 00:51

I admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well.

homes for sale in boise idaho

December 23. 2009 01:32

The beauty of these blogging engines and CMS platforms is the lack of limitations and ease of manipulation that allows developers to implement rich content and 'skin' the site in such a way that with very little effort one would never notice what it is making the site tick all without limiting content and effectiveness.

no loss robot

December 23. 2009 03:10

You may have not intended to do so, but I think you have managed to express the state of mind that a lot of people are in. The sense of wanting to help, but not knowing how or where, is something a lot of us are going through.

no loss robot

December 24. 2009 06:57

Is there a tripod monitor stand available to have a computer monitor displayed from a high position?

monitor stands

December 25. 2009 14:01

Nice information, many thanks to the author. It is incomprehensible to me now, but in general, the usefulness and significance is overwhelming. Thanks again and good luck!

christian dating sites

December 27. 2009 08:49

You got a really useful blog I have been here reading for about an hour. I am a newbie and your success is very much an inspiration for me.

google adwords professsional

December 27. 2009 12:58

Hi webmaster, commenters and everybody else !!! The blog was absolutely fantastic! Lots of great information and inspiration, both of which we all need!b Keep 'em coming... you all do such a great job at such Concepts... can't tell you how much I, for one appreciate all you do!

harley davidson manuals

December 27. 2009 15:03

Thank you for another great article. Where else could anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am on the look for such information.

adwords

December 27. 2009 20:05

I admire the valuable information you offer in your articles. I will bookmark your blog and have my children check up here often. I am quite sure they will learn lots of new stuff here than anybody else!

adwords consulting

December 28. 2009 00:39

I admit, I have not been on this webpage in a long time... however it was another joy to see It is such an important topic and ignored by so many, even professionals. I thank you to help making people more aware of possible issues.
Great stuff as usual...

adwords consultant

December 28. 2009 01:55

I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post

mercedes alloy wheels

December 28. 2009 14:08

This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article

buy bowtrol

December 28. 2009 20:52

You really make it seem so easy with your presentation but I find this topic to be really something which I think I would never understand. It seems too complicated and very broad for me. I am looking forward for your next post, I will try to get the hang of it!

bbc iplayer

December 29. 2009 04:30

Nice post. I love it.

Ggler

December 30. 2009 06:44

Your post is so nice.

Hand blender

December 30. 2009 18:46

I am not much of a guy who thinks in so deeply about web design but I think your post had some valid points in it. Like designers are forced to design stuff within the limited code available and not go beyond it, their innovation is somewhat limited but still I think Web Design won't die! I agree that Amazon and other some big sites won't have a blog but now a days it's very important to have some sort of option available so people can quickly communicate their thoughts. I think Amazon if wants to shift it to that, they can get a customized CMS for themselves.

kit car insurance quote

December 31. 2009 20:01

I have recently started using the blogengine.net and I having some problems here? in your blog you stated that we need to enable write permissions on the App_Data folder...unfortunately I don't understand how to enable it.

acai berry

December 31. 2009 20:39

Keep 'em coming... you all do such a great job at such Concepts... can't tell you how much I, for one appreciate all you do!

web development

January 2. 2010 17:22

There are certainly a lot of details like that to take into consideration. That is a great point to bring up. I offer the thoughts above as general inspiration but clearly there are questions like the one you bring up where the most important thing will be working in honest good faith. I don?t know if best practices have emerged around things like that, but I am sure that your job is clearly identified as a fair game.

Mobile Phone Repairs

January 2. 2010 22:26

I admire the valuable information you offer in your articles. I will bookmark your blog and have my children check up here often. I am quite sure they will learn lots of new stuff here than anybody else!

wetsuits

January 4. 2010 10:09

I was wondering what is up with that weird gravatar??? I know 5am is early and I'm not looking my best at that hour, but I hope I don't look like this! I might however make that face if I'm asked to do 100 pushups. lol

Web Design Las Vegas

January 4. 2010 11:42

Keep 'em coming... you all do such a great job at such Concepts... can't tell you how much I, for one appreciate all you do!

Healthy Eating Tips

January 4. 2010 11:43

That is some inspirational stuff. Never knew that opinions could be this varied. Thanks for all the enthusiasm to offer such helpful information here.

no loss robot

January 4. 2010 11:55

Hey - nice blog, just looking around some blogs, seems a pretty nice platform you are using. I'm currently using Wordpress for a few of my sites but looking to change one of them over to a platform similar to yours as a trial run. Anything in particular you would recommend about it?

regcure review

January 4. 2010 12:20

I admit, I have not been on this webpage in a long time... however it was another joy to see It is such an important topic and ignored by so many, even professionals. I thank you to help making people more aware of possible issues.
Great stuff as usual...

Havanese training

Comments are closed