#pivot

Hi all I am in a trouble to sort out the following to find out exact sum of the pay based on certain role and time period: In one sheet there are names of the positions and per period pay amounts In another sheet, there are positions and the names as well as their tenure/working period during in...

Dear community, Context: I am currently working on some macros that should do the following : 1. Open a (raw data file -.csv) as a new sheet in my .xlsm workbook -> Done 2. Refresh 9 pivots based on the file uploaded with point 1 (update data source of all pivots). The current setup is one...

Hi all, I am hoping someone can advise me on how to set up my pivot table please? This isn't the best way of setting up feedback analysis I am very sure, but I need to work with what I've got! I have survey results from students who have done a variety of modules for their courses and submit...

How to Filter Both Pivot-table Data According After Select Drop-Downlist. "i Try select party name on drop-downlist , After filter both pivotable data on working with drop-downlist (WE NEED MULTIPLE PIVOTABLE AFTER SELECT DROP-DOWNLIST

Hide Row with Zero value with Entry

Can a pivot table calculate two items under one category? Here's an example of what I want to do. I've provided a table of what I want the pivot table to look like when it's calculating the data. I don't know how to add/include actual excel cells into my message so I apologize about that...

Hi I have the below data and need to be able to show the total for certain dates in each month, for example for February I want to show the first 15 days total while still showing the full total for january. I have tried to insert slicer with day in it but once I select the first 15 days it...

Hi I need some help setting up a pivot table. I need to compare sales figures from 2 seperate years for example sales figures from week 1 2016 against sales figures for week 1 2017 for each store. I then need to be able to show the monetary difference between each year and the % difference...

Hi, Pivot is a report in tabular format, based on a TABLE. The TABLE has some columns of download data, and further columns calculating sums and logical messages. I extract the salient rows from the table for this stakeholder, using a tabular pivot format. There are around 15 "Row" columns in...

Hello forum! I have a question for you knowlegeable people; how can I change what's in a pivot's values without actually going to the PivotTable Fields area. Ideally, I'll be using a slicer. This is the raw data: <colgroup><col><col><col></colgroup><tbody> Name Document No. Values John...

hi all, I have an excel workbook in which I want to automatically update selection lists based on the user who is logging in and which selection is made from a few dropdown boxes. The user does the following steps: 1. Login (the username is saved to named range called cCurrent_User in the...

The Data I am pulling from is:<o:p></o:p> <o:p></o:p> <tbody> ATA<o:p></o:p> Claim Amount<o:p></o:p> # Units<o:p></o:p> 11/7/2010<o:p></o:p> $322.89<o:p></o:p> 4<o:p></o:p> 3/29/2011<o:p></o:p> $41.36<o:p></o:p> 24 (4 ctns)<o:p></o:p> 3/4/2011<o:p></o:p>...

The Data I am pulling from is:<o:p></o:p> <o:p> </o:p> <tbody> ATA<o:p></o:p> Claim Amount<o:p></o:p> # Units<o:p></o:p> 11/7/2010<o:p></o:p> $322.89<o:p></o:p> 4<o:p></o:p> 3/29/2011<o:p></o:p> $41.36<o:p></o:p> 24 (4...