Pivot Tables help with creating a calculated field in access

[Davers]

Hi everyone. I've created a pivot table in Access and I need to add a column to it showing a percentage of the total. My pivot table looks like this:

PivotTable83119.HTM
	A	B	C	D
2	Sumofacdcalls	mmyy
3	starttime	Fri-02	Fri-09	Fri-16
4	800	0	0	0
5	830	5	2	7
6	900	11	17	16
7	930	27	25	27
8	GrandTotal	43	44	50
Sheet3

And I need to add a column to it so I can see the percentage...or just change the column to a percentage of the grand total for each total...as shown below:

PivotTable83119.HTM
	A	B	C	D	E	F	G
2	Sumofacdcalls	mmyy
3	starttime	Fri-02	%ofTotal	Fri-09	%ofTotal	Fri-16	%ofTotal
4	800	0	0%	0	0%	0	0%
5	830	5	12%	2	5%	7	16%
6	900	11	26%	17	40%	16	37%
7	930	27	63%	25	58%	27	63%
8	GrandTotal	43		44		50
Sheet3

Is there a way using something like "Create Calculated Data Field" or something where I can insert that? I'd like my pivot chart to show the percentages...

Thanks for any help,

Dave

 

[Norie]

Dave

Is it definitely Access?

 

[Davers]

Re: Pivot Tables help with creating a calculated field in ac

yea...I can do it in a second in Excel...but I'd like to do it in Access...what I've come up with is to create another query which gives me the total for the day. Then I added that query to my other query and created an expression that returns a percentage number....then I closed it without saving... So, once I recreate that...I think I will have what I needed...

Thanks for the help and have a good day and weekend!!!

Dave