Get instant live expert help on I need help with pivot table in access

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I added data to my table. Ive refreshed the pivot table but when I access "builder" within the table, I don't see my new column listed.
Solved by B. C. in 15 mins
I'm trying to total the values in a pivot table. Essentially i want another value in the pivot table which displays the sum of the other pivot table columns.
Solved by V. D. in 18 mins
Make cell A6 Active in the CPIData worksheet. Import the CPI table from the Access database NuTrends Census.accdb.
Solved by O. D. in 30 mins
=IFERROR(VLOOKUPSTR(D26,'Pivot Table 2'!B:Q,16,'Pivot Table 2'!B:W,22,'Pivot Table 2'!B:AD,29,'Pivot Table 2'!B:AK,36,'Pivot Table 2'!B:AR,43,0),0)
Solved by I. F. in 30 mins
Grouping not available in pivot table and cannot have more than one pivot table in one worksheet
Solved by O. E. in 26 mins