thanks a lot for posting this side-by-side comparison of pivot table features in excel and sheets. very helpful indeed, gives a good overview of the one of the most important functionalities of spreadsheets that is pivot table. I recently faced some issues while adding custom formula in Calculated field in excel pivot table. Excel was not able to provide me with accurate results from the custom formula which I entered. Basically I was attempting to get difference between two fields in my pivot table analysis( One was the average of Revenue field and the other was Average of Budget field, =AVERAGE('Box Office Revenue ($)')-AVERAGE('Budget ($)') , the result should have been the average profit as I entered in Calculated field). The values which excel calculated were somehow not accurate as I verified it by doing simple Sum operation to get the difference between two values. Interestingly, when I did the same thing in Google sheets, it all went smooth giving the true figures without any hassle. I tried taking reference from Online sources about adding custom formula in excel during pivot table analysis, but don't know where excel gets it wrong. I would like your views on this difference in functionality.
That's my problem in Course 5 in Google Data Analytics in Coursera - Pivot3x topic. Excel pivot table have limited features compared to Google sheet pivot table. Google pivot table renders correct calculations but Excel is not.
Can someone help me find where the "Filter by Condition" in Excel for PivotTables is? I see that its an option for Google Sheets (7:22) but Excel only allows me to "Filter by Values".
thanks a lot for posting this side-by-side comparison of pivot table features in excel and sheets. very helpful indeed, gives a good overview of the one of the most important functionalities of spreadsheets that is pivot table.
I recently faced some issues while adding custom formula in Calculated field in excel pivot table. Excel was not able to provide me with accurate results from the custom formula which I entered. Basically I was attempting to get difference between two fields in my pivot table analysis( One was the average of Revenue field and the other was Average of Budget field, =AVERAGE('Box Office Revenue ($)')-AVERAGE('Budget ($)')
, the result should have been the average profit as I entered in Calculated field). The values which excel calculated were somehow not accurate as I verified it by doing simple Sum operation to get the difference between two values.
Interestingly, when I did the same thing in Google sheets, it all went smooth giving the true figures without any hassle. I tried taking reference from Online sources about adding custom formula in excel during pivot table analysis, but don't know where excel gets it wrong. I would like your views on this difference in functionality.
That's my problem in Course 5 in Google Data Analytics in Coursera - Pivot3x topic. Excel pivot table have limited features compared to Google sheet pivot table. Google pivot table renders correct calculations but Excel is not.
This is amazing! Thank you so much for this video!!!
This is such a masterpiece!
Thanks man.
Thank you! It was fun to make, but hasn't been very popular. I was thinking it was pretty interesting too.
Can someone help me find where the "Filter by Condition" in Excel for PivotTables is? I see that its an option for Google Sheets (7:22) but Excel only allows me to "Filter by Values".
hi, great video! do you know where to find calculated item in pivot in google sheets?
Here is a video about using calculated fields in Google Sheets Pivot Tables that should answer your question. czcams.com/video/ky-rmkbCq9o/video.html
Thanks!
Oh wow. Thanks, you rock!
anyone with a way around get pivot data in sheets in simpler format?
Thank you
You're welcome! Glad you liked it.