Thank you so much...

life saver

Thanks buddy❤

god tier excel advice

Good one

I have been searching for solution to this for months. You just saved me mate. 👍👍👍👍👍👍👍👍

Resize tables, Hide blank data, check for cardinality if there... thnx for this also❤❤❤

too much talking!

It worked! but what do you need to do when there's a empty row in your pivottable with a value 0.00?

I know this is old, but I'm just finding it, because I'm just dealing with this problem. But, I also have another problem that's the same but different, if you're still checking responses to this video. This fixed my one pivot table. Thank you so much! But, I have another pivot table where the filter is a nothing for empty row labels. The column is brand names. Some of the data is for fees, which have no brand name associated, so that column is empty. (blank) doesn't show up in the filter list. It's just a checkbox next to nothing. I've tried filtering (blank). I've tried filtering "". I've tried filtering 0. I've tried filtering "0". I've tried filtering a space. I've tried filtering " ". I can uncheck it, obviously. And, I have been. But, I'd like to apply this trick you used here, to automate as much as possible, and minimize my number of steps. But, I cannot figure it out. I can filter anything above 0, and that works. But, I'm worried one day the data will throw me a curve, and that will filter out something I didn't know was there. I'd like to be able to filter out labels that are specifically "nothing".

You solved my problem!!! Been trying to eliminate that (blank) in my dashboard. I rarely leave comments, but you helped me a lot. Thanks a lot!

Thank you so much for this. Simple solution that helps a tonne!

tysm

Well done - and I loved the ending!

Trippy.

😁😄😃😀😆😅

You are a genius!! problem solve

10 mns talking 1 mn action you stress me up

How you are dong that zoom feature on your excel?

Can you replace (Blank) in the Column field with "-"

Thank you so much ❤ you solved big problem for me now 😅

Great videos. Do you offer some sample templates so we could practice and follow along?

This video was very helpful! Thank you for sharing

Note to self I have watched this already

Thanks for the video. I want to turn off sub totals for just certain fields in a sub total row. For example, in a sub total row I want to sub total account value, % of portfolio, etc. but I do not want to sub total fields like Dividend Yield as this has not meaning. How can you turn off displaying a sub total only for select fields in a sub total row? Thanks again.

Beats any nightmare/dream I ever had. lol. Well done short film.

My Label Filter cannot be click, may I know why

Thanks😀

The video is not at all clear !!

Kind of childish, but it did remind me of some of the complicated dreams I have.

Bravo. Excellent ending.

Very clever story!

You have no ideaaa how much thiss helpss meeee goshh 😭, i was so stressed out bcs of that one blank and finally i came across this video. I'm not the type who likes to write comments on yt but i just want to appreciate ur work. Thank you so much, hope u have an amazing life ahead ✨

This video is out of order.

Loved the music, and the ''eel" coming out of the train tunnel nearly made me jump out of my skin ;-) Great work. Pity there were no subtitles.

Nice!

Excellent Teacher❤

😮That looks like a lot of work!

well that was special

thanks real help how about using <= ? saw it used once

brilliant, and the ending was superb. typical oh humans. well done

And this kids is why you shouldn’t eat cheese before bedtime 😁

I’m on a short sci-fi story binge and I’m so glad this popped up. Didn’t expect the ending, but I loved it! Nice work!

My dream worlds , on video....Amazing.... Add several gunmen, give me a sniper rifle, and.....Very interesting movie, and the mystery are very good.

Was not expecting that at all. Great job cast and crew. Well written. Story line was thought provoking. " out of order " the sign of our times.

Wow!! Absolutely incredible, great Job Jeff.

so so..

???

Such hard work and great short, nice one guys!

Really cool special effects and an overall job well done! Congratulations, Jeff!