Alicia has attended:
Outlook Advanced course
Excel Advanced course
Access Intermediate course
Pivot Table
Hi,
Hope you're well.
I have a quick question. I've been trying to build a dashboard and I'm trying to make a calculated field to calculate the percentage of the two columns beside it.
The original data is text rows (eg. student records). I want to find out the % of the fields without a certain field, which is how I analyse the numbers for this task.
XXX || xxxxx || first two columns as a %
data 1 || data 2 || (data 2/data 1 calculation goes here)
How would I do this? I don't want to do this manually, as I want this calculation to be contained within the pivot, so that its dynamic like the rest of it. I've looked it up online but it isn't working like the tutorials show me.
I hope this makes sense and thanks in advance.
Best regards,
Alicia
RE: Pivot Table
Hi Alicia,
Thank you for the forum question.
Make sure your Pivot Table is selected. In the Calculations group on the Analyze tab click Fields, Items & Sets and click Calculated field. Type the heading and click in the Formula box. Double click the field names in the Fields box to create the formula in the formula box. =field 1/field 2
I hope this makes sense
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
