Problem sorting Pivot Table according to date
Hi, Attached my Excel Raw Data and resulted Pivot Table. I cannot find a way to sort pivot table row according to date. Have tried to change cell format to date and sorting after that but no luck. 🙂 My customer wants date in a format as shown in column B. Any help is appreciated, thanks!
Excel could not get the source data for the PivotTable report from the disk
I have a spreadsheet with couple of pivots (around 7 pivots) and have a slicer connecting to all pivots on top. But when I open the excel the first time and try to click on something in the slicer, then I get the error - "Excel could not get the source data for the PivotTable report from the disk". If I click again I get the second error - "This PivotTable Report is invalid. Try refreshing the data (On the Options tab, click Refresh.)". If I do refresh all the data, the issue is fixed and the slicer works fine. But the error occurs every time I open the sheet. Any tips on how to fix this? Thanks!Hiding useless sub rows in pivot hierarchy without changing the calculation
Hello, I have the following issue with excel pivot: When I have a table with projects, sub projects and sub sub projects: and create a pivot table, it looks like this: When i try to hide the "(empty)" rows, pivot removes the whole row, so all that's left is the row that doesn't have any "(empty)" values in "Main Project", "Sub Project" or "Sub Sub Project": But what I actually want is the following: I don't want to filter data, I just want to hide hierarchy levels, when they are not needed. I am using SQL Server data and VBA with the copyfromrecordset method. I would prefer a simple solution without VBA or SQL Server but if there is a way with VBA or SQL Server to fix this hierarchy problem in pivot tables, it would be perfectly fine too. Thank you very much for your help and best regards.
Pivot table displaying percentage
How can I get the following output using pivot table or any other way: I am able to get Group and total but unable to get the %. The % scenario is, if 2012 has all X then it is 100%. Likewise following years have their respective X, Y and Z percentage which has to be calculated and display as in the above picture.
Combine Data from Multiple Tables to 1 Pivot When Having Duplicate Values
See attached file. I have a table (Table1) with data of number of resources required every month per Product / per Domain / per Team. So a single product can appear many time in the 'product' column. Creating a Pivot for this Table1 is easy so I can see how much effort is required for each product or how much effort invests every Team along the year. I have many products & many department. Due to internal limitations, I have to divide Table1 so each department will get the same table structure but will fill in different required effort per month. So....I have Table2 for Software and Table3 for Mechanics department and can have more tables for other department. I couldn't do it with the Pivot Data Model since 'Product' column contains duplicate values. So - How do I combine all the tables to 1 pivot or to 1 table and from there creating the pivot?
Problems using Pivot tables in Excel 16.25 on Mac
Hello folks - been trying to use an Excel file with a pivot table created on a Windows machine - the pivot table doesn't work - can't edit, refresh, use filters (slice/dice) or anything. After looking online I joined the Office Insider program and tried to pull down the 16.6 version of Excel as suggested - however all I got thus far is version 16.25 - Doesn't look like there even IS a version 16.6 according to MSFT release notes for Excel. (But there is a video on YT showing how to pull down that version which supposedly does work with Pivot tables...) This is Office 365 subscription as installed from IBM app store (and updated via Office Insider) on a MacBook PRO. Has anyone encountered this and have a solution for it? Thanks!
Excel/ Power Query/ Pivot as a web part in SharePoint?
Hello, I think my question can pertain to Power Query, Pivot, and BI, but I am hoping to get a better understanding of which route is most efficient, accessible, and if there are any things that need to be considered when adding a component to SharePoint. I am not a coder, so without training, that is not a viable option for me :). If I am in the wrong place, please let me know. I've also posted this request in another excel forum, but thought that this may reach a wider audience - apologies if you're seeing this twice. Thank you! Scenario: I have a site collection in SharePoint and want to roll-up tasks from sub-sites to the the Parent. The owner of the Parent needs to be able to easily pull information from the data (point and click to filter for what is needed). After a few considerations, I thought why not export all excel files from SharePoint, import the tables into Power Query, combine all tables, and then make it fancy and easy to interact with either in Pivot, PowerBI, or even PowerApps or Flow and add it to the home page in SharePoint as a web part. Maybe even a mini dashboard with slicers?? I've completed the steps through combine all tables in Power Query. But then thought, how will I best ensure that the data refreshes (and can this even happen), how best can I add this as a web part to SharePoint - there may be restrictions in who can view or how info can be shared in SharePoint with PowerBI, and are there any nuances that I need to consider in adding this data to SharePoint. All insights are greatly appreciated. Thank you in advance. Kerry
Freeze Pivot Chart
Hi, I am wondering if it is possible to create multiple pivot charts from a single pivot table without them all auto updating when I manipulate the data in the underlying pivot table? For example, I create one chart, then I want to manipulate the table to create a second chart but without changing the first. Or is this just not possible and I have to create multiple pivot tables from the underlying data set as I have been doing? Thanks.
Table transformation with PivotTable or Index Match
I have an Excel 2016 file with a large set of panel data in the following actual form: VAR ISO VALUE 1990 1991 1992 IMPORTS ARG 1,287 NA NA IMPORTS AUS 9,178 5,447 10,792 IMPORTS AUT NA NA 1,325 GDP ARG 153 206 248 GDP AUS 323 324 317 GDP AUT 167 174 196 I need to transform it to the following desired form: ISO YEAR VAR IMPORTS GDP ARG 1990 1,287 153 ARG 1991 NA 206 ARG 1992 NA 248 AUS 1990 9,178 323 AUS 1991 5,447 324 AUS 1992 10,792 317 AUT 1990 NA 167 AUT 1991 NA 174 AUT 1992 1,325 196 Can anyone suggest a way to automatically transform the data from the actual format to the desired form: I thought that a pivot table might work. But I don’t know how to do a multi-level pivot table that would have the ISO and YEAR in the same line. Any suggestions would be grately appreciated!
