Awesome, even 13 Years afterwards the best explanation.
@contextures16 сағат бұрын
Thank you! I'm so glad to hear that the video is still helpful!
@CatherineVilsonКүн бұрын
Thank you so much but do you know at all how I can center the horizontal labels?
@contextures16 сағат бұрын
You're welcome, Catherine! There's no built-in way to centre the labels, but you could add space characters before the text in each label, as a workaround.
@yamenjolak9156Күн бұрын
Very complicated
@moekyawnaingoo47922 күн бұрын
ကျေးဇူးအရမ်းတင်ပါတယ်ရှင့်
@contexturesКүн бұрын
You're welcome!
@siddharthsingh3734 күн бұрын
Thanks 🙏🏻
@contextures16 сағат бұрын
You're welcome, and thanks for your comment!
@amitbabani67985 күн бұрын
Really helpful 🎉
@contextures5 күн бұрын
Thank you!
@deepakpoddarpoddar29758 күн бұрын
Thanks for given a good knowledge Very very 🙏
@contextures7 күн бұрын
You're welcome, Deepak, and thanks for your comment!
@klara99589 күн бұрын
Hello that is exactly what I needed. Please is there any way to reference the average cell? I am geting #REF! Error. Thank you. 😊
@contextures8 күн бұрын
Thanks, and in the GETPIVOTDATA formula, remove the word Data, and the comma after it. For example, change this: =GETPIVOTDATA($A$4,"GrandTotal[' ';Data,Average]") to this: =GETPIVOTDATA($A$4,"GrandTotal[' ';Average]")
@sadiyaaurabalqisa90659 күн бұрын
Lady you’re a life savior!!!!
@contextures8 күн бұрын
Thank you, Sadiya, and I'm glad my video helped you!
@carolinacorrea706310 күн бұрын
11 years later … still a helpful video
@contextures10 күн бұрын
Thanks, Carolina, and I appreciate hearing that!
@MoF6410 күн бұрын
Fantastic spent ages trying to find out how to do this. Thanks for sharing your knowledge with the world!
@contextures8 күн бұрын
You're welcome, and thanks for letting me know that the video had what you needed!
@Piera_Mango12 күн бұрын
thanks
@contextures12 күн бұрын
You're welcome, and thanks for your comment!!
@lokesh607312 күн бұрын
Great. This is what I am searching and you saved my time.😎
@contextures12 күн бұрын
Thank you, Lokesh, and I appreciate that!
@wojciechmajewski223112 күн бұрын
Very helpful indeed, thank you!
@contextures12 күн бұрын
You're welcome, Wojciech, and thanks for your comment!
@EdieShack15 күн бұрын
So much more helpful than all the other hits I got for this question. Thank you!!!!
@contextures14 күн бұрын
You're welcome, and thanks for your lovely comment!
@lauramartinez16115 күн бұрын
GRACIAS GENIAAAAAAAAAAA 😀😀😀😀
@contextures15 күн бұрын
You're welcome, Laura, and thanks for your comment!
@justinmoench869015 күн бұрын
Fantastic! Thanks
@contextures15 күн бұрын
You're welcome, Justin, and thanks for your comment!
@punnyabrata17 күн бұрын
Amazing!!
@contextures16 күн бұрын
Thank you!
@yashpokhriyal477718 күн бұрын
Great mam
@contextures17 күн бұрын
Thank you, Yash!
@prekshitmehta443918 күн бұрын
Thanks alots for helping
@contextures18 күн бұрын
You're welcome, Prekshit, and thanks for your comment!
@_immikey23 күн бұрын
12years later and this video is still saving hours of work time. Thank you so much!
@contextures22 күн бұрын
You're welcome, and thanks for letting me know that the video helped you, after all these years!
@letusplay033023 күн бұрын
hi, what if i want to find second largest and second smallest
@contextures23 күн бұрын
In a pivot table, you could show the values as Rank, then highlight the cells that have rank 2. In this video, I show pivot table Rank examples. kzfaq.info/get/bejne/hq-qfql4ntGwmWg.html On a worksheet, you could use the SMALL and LARGE functions, with 2 as the second argument.
@Informativevlogs010325 күн бұрын
So quick thanks for the info❤
@contextures24 күн бұрын
You're welcome, and thanks for your comment!
@alisansar773825 күн бұрын
Thanks for your Good working, I have a query can you please help. I want to view the sale of product like a tree type expend (year than expend months than show in date )
@contextures24 күн бұрын
Thanks, and in this video I show how to expand and collapse pivot table fields: kzfaq.info/get/bejne/idSdeZSBxM21nYE.html
@Syedabidbukhari28 күн бұрын
Fine very good tool to save the time and laborious job convert to a good mood job.
@contextures28 күн бұрын
Thank you, Syed, and I'm glad this video will help you save time!
@subratadas654129 күн бұрын
At 1:00, how did you change all the values to East in one go?
@contextures29 күн бұрын
With all the Central cells selected, I typed East, then pressed Ctrl+Enter to enter that value in all the selected cells
@paulettebrown464329 күн бұрын
THANKYOU!!!
@contextures29 күн бұрын
You're welcome, and thanks for your comment!
@aamirmasood465529 күн бұрын
Excellent video, was looking for this....and this is a perfect video...thanks alot
@contextures29 күн бұрын
You're welcome, Aamir, and thanks for letting me know that the video had what you were looking for!
@martinvictor5028Ай бұрын
Thank you so much. Your video was most helpful. Martin from Malaysia
@contexturesАй бұрын
You're welcome, Martin, and thanks for your lovely comment! - Debra from Canada