#pivot

  1. L

    Pivot Table

    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...
  2. S

    Need Help - Pivot Table - Months/Days

    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...
  3. S

    Pivot Table

    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...
  4. P

    Pivot widths - format so width "sticks" as field order changes?

    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...
  5. Alice Morland

    Changing a pivot's displayed values (from one set to another) using a slicer

    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...
  6. G

    Updating Selection Lists with Pivot

    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...
  7. T

    New to Pivot Tables - problem data

    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>...
  8. T

    New to Pivot Tables - problem data

    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...

Some videos you may like

This Week's Hot Topics

Top