I can’t use tables because I can’t see a way to add rows to the top as my spreadsheet goes from recent down to oldest. So I continually add rows to top. Can you add rows to top in a table?
Mam i need multiple filter option but in pivot filter it shows all value very hard to select. For example country one filter second state filter third town filter.
Want to see what other cool stuff you can do with PivotTables? Check out this video --> th-cam.com/video/_zZd5j84R9c/w-d-xo.html
Great stuff Debs, from a grateful student of yours in Alexander Bay, South Africa.
Thank you for watching :)
Wow!..... Thanks again for the very comprehensive explanation...
You’re welcome!
Awesome video mam
I love this functionality - I only have an issue; I would need to keep the Conditional Formatting created in the original Pivot, is it possible?
Let me test this today and I’ll come back to you :)
Thank you so much@@cellmatestraining
Would I be able to do this and have chicken, classic, and supreme all together in one tab and veggie on it's own tab in this example?
Hi I have followed all the steps, but show report filers pages is greyed out,would you please tell me why
I can’t use tables because I can’t see a way to add rows to the top as my spreadsheet goes from recent down to oldest. So I continually add rows to top. Can you add rows to top in a table?
Click on the first row and go to the Table Design tab. Should have option to add rows above.
Mam i need multiple filter option but in pivot filter it shows all value very hard to select. For example country one filter second state filter third town filter.
@@venkatraman2011 what field are you trying to create filter pages for? You need to select one I.e country OR city OR State.
Wow
😃