General discussion

Locked

EXCEL PIVOT TABLES

By Topic ·
Adding a column to the Pivot table that is not in the main data table and that each cell within that column undertakes a mathematical function e.g. add, divide etc.

Say I ahev worksheet set up as a data table and I then create a reprot using the Pivot Tabel function. However I tehn need to undertake another calculation derrived from the Pivot Table in another column, where each cell can be used to divide multiply etc.

I have tried just adding a column next to the Pivot table, where each cells undertakes a calculation. The problem is, that as soon as the Pivot table is updated or data changes the created column does not update with it, in fact the whole thing is out of sync. The only way I have overcome this problem - which is not the most efficent way, was to create another column/columns in the data table which then undetakes the required calculation, create another pivot table next to the first one - with the same criteria, with just the new two columns. The problem with this is, that it creates a memory hungry file and that if the first Pivot table is updated, one must not forget to update the second table.

Is there a simpler solution?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Bristar In reply to EXCEL PIVOT TABLES

If the data is not confidential, you can email the sheet and a description of what you want so I can see it in detail.

Collapse -

by Topic In reply to

Poster rated this answer.

Collapse -

by michaeltubs In reply to EXCEL PIVOT TABLES

set a second calculation cell for your second pivot table.

Collapse -

by Topic In reply to

Poster rated this answer.

Collapse -

by Topic In reply to EXCEL PIVOT TABLES

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums