Graph Help

[#1]

Hi!

I’m trying to create a table with the following expressions:

• Month

• Working Hours

• Monthly Cost: sum fields cost1, cost2 and cost3;

• Charge per Hour: monthly cost / working hours

This should appear in this way from January 2013 to December 2013:

Repart	Employee	Contract	2013
			January	Working Hous	Charge per Hour	Monthly Cost	December	Working Hous	Charge per Hour	Monthly Cost	Total

You can find an example attached.

Do you think maybe it’s possible also to do a graph in this way?

Any suggestions greatly appreciated.

Andrea

[jonasheisterkam]

Hi, is this what you need?

[#3]

Hi, is it possible to place month fields horizontally for each employee?

In your example, when an employee worked in the same month, but in different years, costs are summed?

Thank you for in advance for your time!

[jonasheisterkam]

No i think not there are Sumed over years. I define the Dim of Your to be only 2013 if you use all Years you get a Month values every year. It is interactiv Pivot you can change alle this vith drag drop on the Dim caption. If you want shure that it is not calculating over the Years you can use monthname.

here is the file again without only showing 2013.