(Sorry for the delay in releasing this, had some technical issues recently - should be fixed soon) Update: might not be fixed as soon as I'd hoped, but don't worry if I can't reply to your comments or upload the next few videos - I'm not doing this intentionally, just tech issues that seem harder for some tech guys to fix than I had hoped.
Would it be better when adding the second Mfg field to the table to use a formula to get the value from the first Mfg, so that adding data to the table will automatically populate second Mfg.
Thanks. If you have Mfr in the Row field and Total in the Values field, you can filter the Pivot Table by Mfr by making a slicer on Mfr or by clicking the dropdown on the Row Labels column in the Pivot Table. It seems the only thing you can't do is move Mfr to the Filters field and still have it show in the Rows field also. Not sure why this would be necessary in the first place, since you can filter in the two other ways described. If you really want to have Mfr in Rows and Filters simultaneously, then a good way to solve the problem is to use Power Query. Load the table to the PQ editor, duplicate the Mfr column which will be named Mfr - Copy by default, close and load to a Pivot Table and you will have both Mfr and Mfr - Copy in the Pivot Table Fields list. You can then use Mfr in Rows and Mfr - Copy in Filters. By using Power Query, you don't have to change your source data table. PQ handles the transformation of your original data without changing it. You only make a connection to it through Power Query and then your transformed table feeds the Pivot Table. The only thing you must do is Refresh Data if anything in your source table changes in the future. Just another way to get there. Hope this idea is useful to someone. Thanks for sharing your tips :)) Thumbs up!!
Been using Excel since 1993 & still learning new tricks. Thanks for this.
(Sorry for the delay in releasing this, had some technical issues recently - should be fixed soon)
Update: might not be fixed as soon as I'd hoped, but don't worry if I can't reply to your comments or upload the next few videos - I'm not doing this intentionally, just tech issues that seem harder for some tech guys to fix than I had hoped.
Annoyingly simple! 👌
Thank you very much!
Would it be better when adding the second Mfg field to the table to use a formula to get the value from the first Mfg, so that adding data to the table will automatically populate second Mfg.
Wow this is really great tips! Thank you so much 💓
Thanks. If you have Mfr in the Row field and Total in the Values field, you can filter the Pivot Table by Mfr by making a slicer on Mfr or by clicking the dropdown on the Row Labels column in the Pivot Table. It seems the only thing you can't do is move Mfr to the Filters field and still have it show in the Rows field also. Not sure why this would be necessary in the first place, since you can filter in the two other ways described. If you really want to have Mfr in Rows and Filters simultaneously, then a good way to solve the problem is to use Power Query. Load the table to the PQ editor, duplicate the Mfr column which will be named Mfr - Copy by default, close and load to a Pivot Table and you will have both Mfr and Mfr - Copy in the Pivot Table Fields list. You can then use Mfr in Rows and Mfr - Copy in Filters. By using Power Query, you don't have to change your source data table. PQ handles the transformation of your original data without changing it. You only make a connection to it through Power Query and then your transformed table feeds the Pivot Table. The only thing you must do is Refresh Data if anything in your source table changes in the future. Just another way to get there. Hope this idea is useful to someone. Thanks for sharing your tips :)) Thumbs up!!
Really Cool Tips..Thank You Sir :)
Muito legal esse conteúdo!
continue firme com os viideos!
the copy and paste doesn't link the pivot table.
great trick
smart solution