Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

I want to edit added calculated fields on a pivot table. It is possible to manually enter values to calculated fields on a pivot table? If not, is it possible to insert an editable column on a pivot table?
Solved by Z. S. in 20 mins
I need to create a pivot table that sums visits per day by provider: Date...Visits....Provider So, I can ask...how many visits did provider X have on day Y?
Solved by F. J. in 34 mins
I have a dataset and pivot tables. Charts not changing when downloaded on a different computer
Solved by Z. D. in 60 mins
Hi, I needs the urgent help on how to hide the negative time value from pivot table of excel sheet
Solved by E. U. in 35 mins
Good Morning I have data with multiple pivot tables. I have a slicer with date ranges, example 07-29-18 to 08-11-18, that brings the data together with this date range. When I choose this date range the data shows blank. When I choose Blank on my slicer the data shows up. I have removed the data and re-entered it. File is very large and has been working up to this date. If I go to the next date range I get the data
Solved by M. L. in 23 mins
I want to learn how to use pivot tables, slicers, Vlookups and charts
Solved by D. B. in 11 mins
I have a database extract that is showing the same clients multiple times in the list. How can I write a formula in excel to look at the column with the client names and return only unique records on another sheet? I want to run this over several files so wanting to avoid using pivot tables which is how I would normal do this.
Solved by X. J. in 20 mins
Need a calculated field in a pivot table that finds the difference between two "count" value fields
Solved by K. S. in 60 mins
Is it possible to unpovot part of a Pivot table.
Solved by M. H. in 4 mins
Hi. How can I do a Pivot Table on a Google sheet?
Solved by M. C. in 4 mins
1 2 3 4 6 7