Hi! Is there any update to incorporate iferror into the pivot table tool? I have blank cells in my data and they return a DIV 0 error when I take the average - suggestions?
I am stuck at one place, nobody better than you, I could ask for.. Suppose I have a sheet with columns Name, Marks in written, marks in interview, total marks. Now I wish to create a pivot that gives, MAX,MIN,AVERAGE of marks in written, marks in interview and of total marks. I want to achieve it through single pivot table how to go about it? Thanks.
I'm not sure if I fully understand what you're trying to do, but it seems like you just need to add the same field to values multiple times and apply different functions.
lol. Spent hours watching your QUERY tutorials just to get a convoluted workaround to grouping. Thank you for this!
Thank you - this tutorial is pleasingly short and delivers what it promises!
Thank you! This grouping feature I hadn't discovered yet. It's insanely cool.
Amazing! Thank you
Thanks for this, and all of your other, great tutorials!
Thanks a lot sir
Thank you very much
excellent video!
Thank you 👍
Very helpful topic. Thank you
Great tutorial!
Group by date! that is what I have been waiting for.
Where do you find info when new things are added to Google sheets?
Laza Lazarevic gsuiteupdates.googleblog.com/?m=1
Thank you.
just wow
Good stuff. Hasta la vista Filemaker
awesome. thank you
Hi! Is there any update to incorporate iferror into the pivot table tool? I have blank cells in my data and they return a DIV 0 error when I take the average - suggestions?
I think you should be able to use it as custom formula wrapped around average function. czcams.com/video/pdLl5IL-ZGY/video.html
can I request for a spreadsheet practice link? thanks
Dear sir how to select all colum name range in one time plz rply
I am stuck at one place, nobody better than you, I could ask for..
Suppose I have a sheet with columns Name, Marks in written, marks in interview, total marks. Now I wish to create a pivot that gives, MAX,MIN,AVERAGE of marks in written, marks in interview and of total marks. I want to achieve it through single pivot table how to go about it? Thanks.
I'm not sure if I fully understand what you're trying to do, but it seems like you just need to add the same field to values multiple times and apply different functions.
what about group by week, how do you do that??
You have to do it in your data before you create your pivot table. Check out Date Functions video.
why if i add new data, the pivot table is not update ?
It keeps the old range. You need to update the range.
Thank You Very Much