Hi I came across a problem I want to show months with no sales as 0; which means we sold 2 in the first month second month sales is 0 which need to be shown as 0, 3rd month sales is 2 And I want to show no value for new products in the pivot table, which means we have no sales till now and it should show as no sales; i dont want to display in pivot table as 0 Is there any way we can do it
My Excel playlist with over 250 videos is here ruclips.net/p/PLsYjn_fAfG42S1JmTFr7B5eTQRvm5w3sF the most recent videos are at the top!
I have watched a lot of videos to help me with excel, and this is by far the easiest to follow.
Thank you so much, I was looking for a way to present my data and this video really helped me
You're welcome!
i don't usually comment on these things but this was SUPER helpful and quick. thank you for both.
i really appreciate the short and clear video format on these things. This was a big help!
Excellent, this is what I am looking for, thanks a lot!
Thank you so much sir! It's really helpful!❤
Most welcome!
That was direct. Thank you buddy!
You're welcome
Thank you thank you thank...this is great!! So helpful
You are so welcome!
cheers dude I got stuck on this one thanks for clearing it up
No problem 👍
thank you very much for the tip!
Happy to help!
Thank you!!!
Welcome!
Good!
Thanks!
I need this but with a rolling 12 month with dates falling into two years. It keeps adding months I don't want included.
Hey Chris, Thanks for your video. I am however not able to do this as my show item without data option is greyed out. Any help with this???
Hi
I came across a problem
I want to show months with no sales as 0; which means we sold 2 in the first month second month sales is 0 which need to be shown as 0, 3rd month sales is 2
And I want to show no value for new products in the pivot table, which means we have no sales till now and it should show as no sales; i dont want to display in pivot table as 0
Is there any way we can do it
the "show items with no data" is grayed out on my end, how to resolve?