Thank you Mark, great to see a different use of the PIVOTBY function (rather than the usual videos) and with slicers, this makes it very powerful. Can't wait to get hold of it now!!
@ExcelOffTheGrid5 ай бұрын
The good news is that you can use this technique with FILTER right now. 👍
@ennykraftАй бұрын
You're the GOAT! Thank you! Could you maybe do another video about all the different calcations in GROUPBY and PIVOTBY? I love what ARRAYTOTEXT in combination with SUBSTITUTE does. Maybe examples for LAMDA? Another question: I've noticed that in my version there's an extra option in GROUPBY called field_relationship. Do you know what that one does?
@IvanCortinas_ES5 ай бұрын
Spectacular BYROW-LAMBDA-SUBTOTAL combination. Thanks for sharing Mark. Excellent tool research.
@ExcelOffTheGrid5 ай бұрын
Glad you enjoyed it. I've got more on that function combination coming next week too. 👍
@ivanbork41755 ай бұрын
Very interesting, and very well introduced. I´m looking forward to the update that include this function.
@ExcelOffTheGrid5 ай бұрын
Hopefully it comes soon, but might be a little while yet.
@valeriastrafe51044 ай бұрын
Cant wait for these formulas to be available in my Excel version
@Excelvenky5 ай бұрын
This is amazing and totally speechless 🤩.. gratitude and thanks
@ExcelOffTheGrid5 ай бұрын
Thank you. I’m glad you liked it 😁
@whowhatwhenwhyhow92655 ай бұрын
Thank you. Great video, great teacher.
@ExcelOffTheGrid5 ай бұрын
Thank you. I’m glad you liked it.
@DataVisualisation5 ай бұрын
Very elegant and fast solution 👏
@ExcelOffTheGrid5 ай бұрын
Thank you! 😊
@MichaelBrown-lw9kz5 ай бұрын
Wow, this is impressive.
@ExcelOffTheGrid5 ай бұрын
Thanks - I really like this slicer technique, there is a lot of potential with it.
@jerrydellasala76435 ай бұрын
Very nice!
@ExcelOffTheGrid5 ай бұрын
Thank you! Cheers!
@mahmoudfawzi5 ай бұрын
do you have a complete course for VBA? i'd love to attend and even pay for that
@ExcelOffTheGrid5 ай бұрын
Sorry, we don't have a VBA course. It's on the roadmap, but might be a way off yet.
@VenemAcademy5 ай бұрын
Thnx Mark. Is this new function the traditional pivot table killer? Does this also work with datamodels through Power Pivot?
@ExcelOffTheGrid5 ай бұрын
Yes, this is the new function. Personally, I don’t think it will be a PivotTable killer. It doesn’t work directly with Power Pivot. You would need to spill some CUBE functions, then work with that spill range. So, I’m sure there could be ways, but probably quite flakey & difficult.