A Slicer For The GROUPBY Function

[@IvanCortinas_ES]

Excellent interactivity. Many important advances are being made with these GROUPBY and PIVOTBY functions that allow many use cases to be solved. Thanks for sharing, Nabil.

[@Officeinstructor]

Yes, you are right

[@tamersalem7542]

رائع جدا وشكرا على نشر العلم والمعرفة تحياتي لشخصكم المحترم ا.دكتور نبيل مراد❤

[@Officeinstructor]

Thank you so much

[@nadermounir8228]

This is a brilliant video. Thank you Nabil :):):)

[@Officeinstructor]

My pleasure 😊

[@JoseAntonioMorato]

Dear Nabil, Slicing for the GROUPBY or PIVOTBY function can also be done by replacing the SUBTOTAL function with the AGGREGATE function: from SUBTOTAL(103;x) to AGGREGATE(3;5;x) And the MAP function can also be replaced by the BYROW function. 🤗

[@alializadeh8195]

Thanks

[@Officeinstructor]

Welcome

[@arijeet1979]

Wow! Thanks

[@Officeinstructor]

Always Welcome!

[@yousrymaarouf2931]

excellent

[@Officeinstructor]

Many many thanks

[@shoppersdream]

Group by Function is not available on Mac. Thanks

[@Officeinstructor]

I cannot help with that

[@ALG_1983]

Good

[@Officeinstructor]

Thanks

[@tamersalem7542]

ممكن بعد اذنك شيت اكسيل لتطبيق عملي

[@Officeinstructor]

So long as I did not mention it in the video, then I am not sharing files for this tutorial. It is very easy to create your own sample file.