Calculated field – pivot table (win XP Of 2007)

Topic

New Reply

I have a pivot table with dates in the rows and expense clasifications in the columns. I summarize expenses by month and by expense classification. I want to add a percent of total in the final total fields, which involves dividing the total of each expense by the full total. When I try to create a calculated total, I can’t seem to use the pivot table’s calculated total.

Any help, please

Reply | Quote

Replies

In earlier versions, you can use Show As to determine how a data field will be displayed (as a percentage of the row total, column total or grand total, for example). But this will apply to the data field (the “interior” of the pivot table) as well as to the totals. I have no idea how it works in Access 2007.

I would prefer to use a pivot table in Excel based on the Access table or query; pivot tables in Excel are (in my opinion) much easier to use.

Reply | Quote

I can live with toggling the “show as” from normal to % of row in the short term, although I would prefer to be able to see both currency and % of total side-by-side. Let me investigate the Excel solution and see how that works.

As usual, thanks for the guidance.

Reply | Quote