pivot table 365

Hi, I have a pivot table that was generated by using a power query data model. I have a filter on the pivot table called "EmpName" and I would like to iterate through all the EmpNames in the filter, copy the resulting pivot table data to a new workbook and save it as an entirely new workbook...

Dear All, I regularly use Power Pivot and Pivot tables for various analysis and drill through the figures to see what combination of transactions makes those figures. In my raw data there are 44 columns. Every time I drill through, I get an exploded view of that table showing raw data - all 44...

Consider the following table DateInvitedAttendedisNotAbsentJan-23Wadeattended and performed1Feb-23Daveattended1Mar-23SethabsentApr-23Ivanattended and performed1May-23RileyabsentJun-23GilbertabsentFeb-23Jorgeattended1Mar-23Danattended and performed1Feb-23Brianattended and...

Require some assistance please. Is there a way to only filter or highlight in a colour to only show the EMPLOYEE NUMBER (from my screenshot sample) which has CODE DC and XC "underneath it" Or if there is a better way to do this on excel. Thankyou

Hello All, I am trying to create a pivot table which should show the distinct values for Data elements in Column 1, these Data Elements are connected with Objects 1,2,3 with the names given in the table below. Data E Object 1 Object 2 Object 3 Account ID ACC_ID DQ_R1 DQ_C1 Account Code...

Excel Office 365 I have a pivot table with dates across the top in row 1, names in column A, numbers in the cells below each date for each person. I am looking for a way to provide a sum of the numbers for the dates that are on Friday, Saturday, Sunday while still keeping the other dates and...

I tried seeking help earlier but struggled at explaining what I'm trying to accomplish. In an effort to simply my issue, I've relabeled my pivot table to represent sport statistics. It's not the best example but I'll try. Below is an image of my pivot table where I am trying to display player...

Hi all, I currently have a bunch of files that are 99% similar, except they have some different data in their columns. The first two rows will always look like this: Unfortunately, the first row messes with the power query, so it returns this: If I remove the first row, my file works such...

Data contains sales information of 400 sales people for each sale which amounts to about 100,000 transactions or rows. Using Pivot Table to list the each sales person and filtering to the Top 10 and use the Do not filter Grand Total option. How ever I would like the pivot to have a total for...