pivot table % formatting

  1. S

    How to set the Pivot Table Layout

    As shown in below Table. "F" has sold 2 items out of which one is defective. i.e. 50% of what he has sold is defective. How do i represent this in Pivot Table? I am unable to figure out the Layout. Raw Data: Sales Executive Products Sold Defective F XYZ NO D XYZ NO F XYZ YES C XYZ...
  2. J

    Using % of Parent Row Value in a Calculated Field

    I am looking to create a calculated field in my pivot table using the value generated from the 'percent of parent row'. I'd like to multiply it by another column but am finding that this might not be possible. Is there a way to do this? Or if not, is there an alternative? The pivot table has 4...
  3. P

    URGENT: Pivot table from set with repeat data, blank cells

    Attached is a sample of the data set I am working with. I am trying to figure out how to create a pivot table so I can easily filter and see numbers like: -How many dogs vs cats were adopted -Who adopted the most number pets -Which city had most number of pets up for adoption -Of those, how...
  4. Y

    Pivot Table Percentage Change

    Hello, I have a pivot table that shows the usage of a material. It shows the target amount of boxes, the actual usage of boxes and the variance between the target and actual. The columns are in the values field. I can't seem to find a way to get excel to use the values field to create a...
  5. X

    Created a column for Month (integer) in a named range, trying to display it as a named Month (ex. "March"), excel keeps reading this integer as a day.

    Right now I am working with a data table, to which I added a 'Month' column, as an integer (1 for January, 2 for February, etc.). While pulling this data into Pivot Tables using the Month column, I wanted to display the months as actual names Months - 'January, February', etc. When I edit the...
  6. H

    Code to auto fill down using Macro

    I extracted data from another database. I want to make this data in pivot table formatting, which means fill Country and Product Column in every row so I can do analytics by country or by product type. There are 15000 rows. How can I do it using Macro? <tbody> B C D Country Product Product...
  7. K

    Pivot table format problem: Moving the body of the pivot table or formatting the filter value cells?

    Hello all, I am wondering if it is possible to move the body (column/row/values) area of a pivot table so that it does not sit directly below the filters. Likewise, if that is not possible, is it possible to merge the filter values across multiple cells (excel won't let me do either upon...
  8. L

    VBA Macro set column width in a Pivot Table on creation

    For the life of me I can't find where I can set the Pivot Table's column size for just xlColumnField and I've spent far too much time on this simple little thing. grrrr I have several macros that auto generate pivot tables based upon criteria. I want the Autofit columns to be turned off after...
  9. K

    Pivot grand total % calculation

    I am working on a pivot table to look at data of previous quarter and current quarter. I got a grand total in the bottom for each value. However, when I am putting a formula for % change from previous quarter to current quarter, in the grand total, the % change is not based on total and it is...
  10. K

    % of chnage from prior period to current period

    Hello I have pivot table where I am showing prior period number and current period numbers. I would like to add a column in pivot table that auto calculate the % change from prior period to current period. Please help me how can I add the field to show % of change.
  11. M

    Pivot Table Conditional Formatting for Minimum Value falls apart with Filters

    Hi Mr Excel board, been using you for a few weeks now. I have been tasked with creating a Pivot Table each week for our buyers that will highlight the lowest price from a vendor for each item. I used the solution found at Highlight the lowest and highest value in an Excel row or column -...
  12. M

    Pivot Table -- I need the "show value as" to stay the same even when some values are filtered

    Hi, I have a Pivot table in which I am tracking the rate at which two different values (P and F) occur annually. However, I only need to graph the rate at which P occurs. I have been able to show the rates in my pivottable by using the "show values as % of parent total." The problem I'm...
  13. P

    templates for Formatting piovt tables

    is there a way to save templates that can format pivot tables? defuault is classic but can we save a template that does not display sub-totals and grand-totals?
  14. V

    Modifying value fied setting for all fields present in the values section of a pivot to %age of total

    Hi, I just put a pivot together which had values for every day of the month for the last 6 months... Think of it as the values of 4 or 5 stock prices being tracked on a daily basis over the past 6 months for 5 clients or something... Once I was done with bringing down the sum of around 180...
  15. srizki

    Comparative Bar Chart formula

    I have cost center numbers in say column A, column B, C, and D house, Standard time, over time and double time , I am asked to provide the comparison of standard, single and doube overtime, that is expensed to these cost centers. what formual should I use or how can I do this. Thanks
  16. G

    % of Total without including subtotals

    Hey, I'm using a pivot table for a production report. I want to subtotal the rows but when viewing the % of total I dont want the subtotals to be counted. Its counting each subtotal as a percentage of the whole...somenone help! Thank you!! <TABLE style="WIDTH: 502pt; BORDER-COLLAPSE...
  17. P

    How To Highlight Cells in a Pivot Table Based on Values from Another Field

    I have a data set where certain values of my results field are 'flagged' in an adjacent field. I'm using a Pivot Table to organize the raw data, and I need these 'flags' to carry over - ie some indication that a given cell in the Pivot Table has been flagged (either highlighted or bold/italics)...
  18. D

    Retain manual formatting when a pivot table refreshes

    Hi, Is it possible to manually format a pivot table in such a way that the formatting is persistent? I'm using Excel 2002 and am not 100% happy with any of the built-in formatting options. Thanks, Doug.
  19. J

    Pivot Table Drilldown - % formatting

    Hi all, I have a pivot table drawing on a data table holding %'s. When I use drill down it brings through the %'s but they are not formatted as %'s. For example in the data table I have a value of 75%, when using the pivot drill down the output is 0.75. Is there a way of getting excel to...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top