Thank you. It helped me a lot today. With this I made a very important document for my team.
@andydataguy
3 жыл бұрын
I'm so thankful for your videos.
@diegoz8855
3 жыл бұрын
wow, beyond helpful. thank you. Who cares if you cant spell, as long as you know the formula! Thanks a million!
@iammagsj
2 жыл бұрын
Thank you so much for the vlookup how-to!!
@LucianoPanepucci_EditoraCubo
5 жыл бұрын
I can't believe I didn't know this yet. Thanks!
@AkaExcel
6 жыл бұрын
I think after update 2018 in 13:28, there is a Default name appeared in Values(Sales) small Window, if You click it there are grand totals, row totals and column totals.
@NagusJJP
5 жыл бұрын
I am trying to find a way to create a calculated field that references the totals and grand totals in my pivot table and Id love to know a bit more detail about what you are referring to here.
@russianilpapa
4 жыл бұрын
@@NagusJJP Did you ever find a solution to this? I'm currently running into the same issue.
@NagusJJP
4 жыл бұрын
Natasha Yonkof sadly, no
@abhishekpuvvada5847
3 жыл бұрын
Super simple and easy to follow through. Thanks man! Can we also sort the pivot table based on month of a date? I found it to be considering only ascending and descending.
@AleksandrPletnyov27
4 жыл бұрын
Great video, maybe you can also create a short How-To calculate running total day by day in Pivot Tables?
@KirilIliev_Utube
3 жыл бұрын
Maybe a custom function in Apps Script can do the job to get the total from the pivot. - No it does not work. But a dirty workaround is to place a ref somewhere else and refer to it in the formula. But I guess you've already did that. Commented too soon Great videos by the way.
@aemma_official
4 жыл бұрын
Loved the vlookup! How will a sleep now! 😅 I’m also trying to find a way to build a table with change between two values per row/column. Like compare 2019 vs 2020 in % , anyone knows if this possible with calculated fields or pivot tables?
@CH-ul7qw
6 жыл бұрын
Thanks for sharing very useful technique! I am struggling to search how to add cumulative total as calculation field on Pivot table. like Day 1 = 2 , Day 2 = 4, (Cumulative total becomes 6)Can you please help me in your next video?? Many thanks
@talebbagazi1435
3 жыл бұрын
satisfaction score may i use that to analyze data which isn't a nominal?
@stagebluedata6889
5 жыл бұрын
If the header labels of your pivot table data range are in row 3 and not row 1 AND your data range is A1:N (so you can capture new data), what do you reference as the header name in your calculated field? Example: you use =Sales/COGS and it works perfectly because your header names are in row 1. If your header labels were in row 3 of the data range, what would you reference in your formula? Thanks!
@prahalladjena1634
2 жыл бұрын
Please tell me how to use pivot table purchase and issue two different sheets and output in one sheets in Google sheets.
@trushitkakrecha1472
5 жыл бұрын
Custom Formula Doesn't recognize Column Name in many Cases
@mikeszymczuk8623
3 жыл бұрын
How can I compute percentages for subgroups in a Sheets pivot tables?
@melvinestrella735
2 жыл бұрын
How do you hide the pivot editor so everytime you click anywhere in the pivot table it won't show?
@ccbg82
2 жыл бұрын
Hi, I always got this error when trying a calculated field: Unknown range name: 'SALES'.
@jean-sebastiendesmarais6019
3 жыл бұрын
Very informative video, thanks! Around minute 13 when you create a percentage of total sales, you can (now) just do it as a "percentage of column/row." May not have been an option when you posted this years ago! hehehe My question is I'm trying to do an AVERAGEIF function using and the criteria is a binary 1 or 0 (so let's say average sales for a single state, IL in reference to your example), I have =AVERAGEIF('column_A_Title',"=1",'Column_B_Title') and I get NA as an error.. any thoughts?
@ExcelGoogleSheets
3 жыл бұрын
It's possible that AVERAGEIF requires ranges to be actual ranges from the spreadsheet.
@rashmiranjan86
2 жыл бұрын
Hi, Is it possible to add a custom field which will subtract the respective row value from the grand total?
@ExcelGoogleSheets
2 жыл бұрын
I think this video should help kzitem.info/news/bejne/zIijrqV7bqh1n6Q
@TheAireaidLord
Жыл бұрын
How the hell do these formulas work? I don't understand how how to make the formula I always get an error
@stagebluedata6889
5 жыл бұрын
I'm trying to copy and paste a pivot table from the Tab (sheet) it was created on into my dashboard tab within the same workbook. When I copy and paste the pivot table my MAXIFS function in the pivot table calculated field stops working and the data ranges that I have referenced turn into #REF symbols. Any idea why this is occurring? The MAXIFS formula in the calculated field works fine as long as the pivot table remains on its original Tab. Thanks!
@gpcasyao2919
4 жыл бұрын
I'm getting a formula parse error when trying this. I even copied and pasted the column names just to be sure I'm entering the correct fields to be calculated
@blodgriskatten
2 жыл бұрын
Same here did you figure it out?
@geoffcrozier
4 жыл бұрын
I've created a calculated field in my pivot table and called it value_1. Does anyone know if I can reference value_1 in a subsequent calculated field?
@vascovasconcelos1783
5 жыл бұрын
I am not getting the same "menu" when I create a calculated field. I basically can not edit the name nor Am I being able to create a formula
@AndreKochDre
5 жыл бұрын
How do you use custom filters?
@razvanstanescu259
4 жыл бұрын
hi, thanks for this! 1 q: how do I save my calculated field so that I dont need to insert the formula over and over again? thanks
@dimkir100
5 жыл бұрын
Is it possible to use within "Custom Fields" formulas written with App Script (Script Editor)? My situation is that I am looking for some text processing functions and looks like the only way to bring in text processing/analysis functions into pivot tables is to use App Script for that...; My use case is pretty specific: instead of processing sales data which is mostly numeric, I need to process dataset which is result of many people filling out forms).
@ExcelGoogleSheets
5 жыл бұрын
Not sure, I'd be interested to know too. Never tested this.
@farhanahmed8297
6 жыл бұрын
Is there a function in Google Sheets similar to the one in MS Excel that changes the Report Layout of a Pivot Table to a Compact view?
@ExcelGoogleSheets
6 жыл бұрын
I don't think there is one.
@lazalazarevic6192
5 жыл бұрын
And how to do the Calculated field if the label of columns are bi-lingual (arabic and english)?
@ExcelGoogleSheets
5 жыл бұрын
I never had to do this, so frankly I don't know.
@techierobin4063
6 жыл бұрын
Will filter and sort function work in pivot table. As i would lok to sort the table in asc order on sales
@ExcelGoogleSheets
6 жыл бұрын
You can sort and filer in pivot tables, you don't need the functions.
@VSR813
11 ай бұрын
6 years passed and still no solution from Google for % of total...
@GreenGlassScarab
2 жыл бұрын
I don't understand your "revenue per state". 5:35 The 7 different states in Midwestern should each have a different revenue, not a single figure.
Пікірлер: 48