Forum Discussion
Need Assistance with Pivot Tables
Hi Jankysoft ,
How are you going to shoehorn into a solution that involves an additional file, when you can do a query on the same table that is already in your workbook?
You can do a query by Table/Range, image below I have a table/range with 53,000+ rows:
I remove the columns I do not want in the report or pivot table, I can rearrange the columns, I can filter out any rows I do not want to be in the report, and if there is additional information, all I have to do is paste it at the bottom of the table and the excel table will just dynamically (automatically) add it into the table and automatically propagate into the report (via the refresh) button and bam! it's included the next time I have to print the report. Does that not sound like convenience to you?
cheers
I saw that as a solution but that looks like the most overkill as it looks like I would be shoehorning in a solution by incorporating at least an addition file to compensate for Excel's lack of features.
Thank you for your assistance, but I think that this all just confirmed to me that Excel is heavily limited to...not sure what but I am trying to be diplomatic as my username already says what I think about the company.
Again, thank you anyways!
Hi Jankysoft ,
How are you going to shoehorn into a solution that involves an additional file, when you can do a query on the same table that is already in your workbook?
You can do a query by Table/Range, image below I have a table/range with 53,000+ rows:
I remove the columns I do not want in the report or pivot table, I can rearrange the columns, I can filter out any rows I do not want to be in the report, and if there is additional information, all I have to do is paste it at the bottom of the table and the excel table will just dynamically (automatically) add it into the table and automatically propagate into the report (via the refresh) button and bam! it's included the next time I have to print the report. Does that not sound like convenience to you?
cheers
- Thank you for your reply once again!
Tried pivot tables and it didn't give me a problem this time for some reason!
Thanks again!Hi Jankysoft ,
Power pivot and power query is like peanut butter and jelly, they compliment one another, i can create a dynamically (automatically) updating pivot table by leveraging power query and data model. By using those two features in excel I can have a power pivot dashboard summary automatically update without recreating the pivot table from scratch, which is made possible by power query. Power Query was designed to clean and prep data for use in data model and power pivot.
cheers
I do not see options to use Power Query without importing in a file still though. However, I am interested if this is not the case. Do you know a good article or LinkedIn / Youtube video to view on Power Query?