THIs seems much more time consuming than a pivot table. But worth a try.
@tammiesspark
8 ай бұрын
By the time you've entered this formula, I will have selected the entire table, click Insert Pivot Table, checked the box for my fields, and am now reviewing my data.
@babuvgl
8 ай бұрын
How about using the pivot table and slicers to filter out the summary?
@jeremymorris-jarrett2111
8 ай бұрын
Advantage of the pivot table: faster to create and you can double-click a value to see what it's made of. Finally, mastering the list of arguments of pivotby seems hard. Disadvantage of pivot table: if you create multiple tables from the same range the tables might synch even if you don't want them to.
@rschloch
7 ай бұрын
What does double clicking a value do? I‘d test it out myself, but i am laying in bed.
@PaulEBrownbill
4 ай бұрын
I am still not convinced by this having watched this, and other videos on the same topic. I would still use pivot tables. Good explanation though, thanks Paul
@gesangvereinoberwolz411
3 ай бұрын
One very big benefit is, that this Pivotby is updated on every data change and your default pivot is not.
@dirceubernardes
8 ай бұрын
I don't have this function in my Excel 365.
@stevereed5776
8 ай бұрын
Thanks for the video, seems like a nice option. I think there is a reason to use both options. Is it possible to create a tabular style table as I do create a few of these? Thanks again.
@mlissd
8 ай бұрын
why is this easier than using the table with everything called out?
@arturmusialak8704
8 ай бұрын
No need to refresh pivot is a huge difference
@dirceubernardes
8 ай бұрын
@@arturmusialak8704agreed. I will definitely start using it
@samdingus
8 ай бұрын
@@arturmusialak8704 I would prefer not to go through this very clunky, inflexible approach for the sake of saving one click! Personal preferences I suppose, but I can't see anything in this clip that will move me away from Pivot tables.
@robinmohan93
8 ай бұрын
Just logged out. Will try on my daily report and will post the feedback 😊
@sohailarshad426
4 ай бұрын
a Bit complicated , but the only advantage I see is the automatic update , in Pivot table you have to refresh after each change , not in Pivotby function .
@cathjaune1180
8 ай бұрын
This is amazing
@Void-tp4yv
8 ай бұрын
This is cool but I don't have this function in my Office 365.
@m.w.6099
8 ай бұрын
It is not there yet
@michaelmoyzik1936
2 ай бұрын
@@m.w.6099 so we are in the middle of July. Still no traces of PivotBy function 🤷♂
@rschloch
7 ай бұрын
I Wonder what the value of This is. Wirhout testing anything, it seems like it could be Used to create dropdown lists and dictionaries for less-Advanced users like myself. I would actually be happy if someone told me why i am wrong!
@Kalobeeeee
8 ай бұрын
This seems cool but not practical. Our report audiences would like to pivot, filter, and dive into the data themselves. This would be a nightmare for them.
@shareitwithit7323
8 ай бұрын
I'm fun for your channel but would you make it easy to understand.i didn't get it.
@connermiles7425
7 ай бұрын
This seems way over complicated than using the pivot table.
Пікірлер: 25