Get instant live expert help on I need help with pivot table sql server

“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 am unable to connect to excel from Azure SQL server.
Solved by B. J. in 12 mins
How to import and manipulate data from a website. Do I need an SQL server?
Solved by E. E. in 17 mins
In EXCEL 2016 HOUR Function in Pivot Table SQL fails with "Hour is not a recognized function"
Solved by V. F. in 14 mins
I want to know how use the "PivotTable.CommitChanges" properly. I have enabled EnableDataValueEditing = True so i can change the value in the pivot table, however i can't seem to get the value committed to the sql database table.
Solved by F. E. in 22 mins
I have a pivot table of Server names that are duplicated down a list of database /table names. Total count is >500 but I want to show the distinct count in the pivot, which is closer to 90. I'm in 2010. I've tried inserting a formula =counta(), but it isn't working and 2010 does not have Distinct Count in the field value settings. Can you help?
Solved by S. Q. in 22 mins