Google Sheets Pivot Table - advanced features (calculated field, display modes, date grouping)

Part of a free online course about Google Sheets:
• Getting started with G...
In this video we discuss more advanced features of the Pivot Table in Google Sheets. More exactly:
- What are calculated fields - and how you can have simple calculations within the Pivot
- Display modes: how to display the values as a percentage instead of an absolute calculation
- Date grouping: how to group dates by month, quarter and year instead of by day

[@nssdesigns]

the double date column was a very good advanced option 'thank you'. i will use this immediately on my reports!

[@habitatforhumanityvancouve367]

Hey Radu - thanks for your informative video. I was specifically interested in the dates grouping at the end of this tutorial. I wonder if there is a way to group specific date ranges? For example, I want to have the pivot table report on everything between Jun 8 and Jul 22 inclusive. Is it possible to do this - there is no option in standard right click grouping. Thanks!

[@rashmiranjan86]

Hi,
is it possible to add a custom field where it will subtract the the respective row value from the total number?

[@Dee-mg6rj]

Is there a way to put grand totals at the top of the pivot, in excel this is possible but can't seem to do it in sheets?

[@velocitypta]

Thanks

[@andreapinto9503]

Hi. Why does my pivot table show dates instead of values when I am bringing in values to the pivot. Please help!

[@mistyhaskett3477]

Instead of Create Pivot Date group (at 5:42) I am getting "Create Pivot Group rule"....but my date is not in the same format...is this why?? My date is simply yyyymmdd

[@japponocofficial8250]

Is there a way for us to change the design of the Pivot table on Google sheet?

[@rpopa]

Not really, we don't have the same options like in Excel

[@LotfyKozman]

Is there a way to create a calculated ITEMS like in Excel?

[@rpopa]

So far only calculated fields from what I know

[@vinitagrawal8033]

how to add if condition in pivot google sheet?

[@dnykm1126]

how to make pivot with multiple consolidation ranges in google sheet?

[@rpopa]

See this video, might come handy.
th-cam.com/video/UpKhpO0Zvl4/w-d-xo.html

[@dnykm1126]

@@rpopa thanks

[@marionbonnard5516]

How do you Perform Year over Year Analysis with a Pivot Table? In Excel there is a feature "show values as" and we can choose "%Difference from previous" and include that value into Pivot Table directly.
I am not able to send you a screenshot on this comment but I found an Excel tutorial about this topic: th-cam.com/video/2sJpcBUckK8/w-d-xo.html
How can we do the same but with Google sheet. I've been struggling for 4 hours now.

[@TheAireaidLord]

Calculated field is easy???? Its literally the hardest thing on planet earth. Every formula gives me a name or parse error. Like wtf is wrong this stupid program