“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hi, I have created a pivot table and want to create a calculated field representing the percentage of hospitalizations (hospitalizations divided by population). I am having trouble with this as the calculated field option is disabled. Please help! I am desperate

Solved by O. J. in 19 mins

What's the easiest way to find out the percentage of two data that contain with the total sales quantity and return sales quantity by simply a click of sale item name (like Pivot Table)?

Solved by S. Y. in 11 mins

I am trying to set-up a pivot table column that is a percentage calculation using two other columns

Solved by I. J. in 14 mins

I need help in establishing relationships for pivot table creation. I have two sources of data that I am able to import onto two worksheets. The first table has item numbers, width of the item, height of the item, price of the individual item.
The 2nd table has the model number, width, height, and total number sold for the year. I am needing a few pivot tables. I need a price grid of individual models by width and height (width is my column, height is my row, filtered by model # - got that far) I need to add a coloring (conditional formatting) to the values by sales.
I need another pivot table that can do a grid that can compare the price of the base model to the chosen model.This grid would have a percentage of the difference in price. still with the width in column and the height in the row.
Beyond the basic single price grid by size....I am lost

Solved by F. J. in 25 mins

I am building a pivot table report where I am showing the percentage difference of sales between different sources in week 1,2,3, etc. I know how to write the formula so it gets the percentage difference but what about the weird variables where let's say a source only sold on week 2 and not week 3/4, how can I make a formula that accounts this weird variables?

Solved by T. W. in 14 mins

I need assistance creating mix of a pivot table and a formula to sort the data I need for that table. You'll see in the file a tab called "Master Pool". This is where all the data will be extracted from. The most important data is column A - Header "Accnum" (this is the data that we'll count in any pivot tables), column O (Header-"Item Type"), and columns V,W,X, and Y (Headers Accessibility (1-4).
The resulting report I need has to show the data points in V,W,X, and Y by the data in the column "Item Type".
This is the issue I'm having: The data in columns V,W,X, and Y for each accnum is presented in different order, often separated only by a comma. On the tab "A11Y Tag" you'll see all the available options that can go in each one of these fields. The header on those tabs matches the headers on the "master pool" tab.
The issue is extracting that data for each item in a way that doesn't show overlaps (i.e.- the same data can be in multiple columns), extracting it in a way that ignores the commas and lack of spaces, and the resulting report will be easy to read.
The resulting report must also show a percentage breakdown of items with accessibility data/ and those without. This info is easy to get, it's in column T ("Metadata Present?") on the tab "Mast Pool".

Solved by F. J. in 26 mins

Hi I am trying to put together a pivot table for each medical center, employees percentage, physicians percentage, and combine total of employees and physicians

Solved by S. Q. in 12 mins

I need a column to calculate a percentage in the pivot table for each year, and then also for the totals columns. The percentage should be percentage of claims with CAT code out of the total amount of claims. Example the percentage of column C/B, E/D, and G/F.

Solved by K. D. in 16 mins

I have two columns in an excel pivot table. Both columns are showing data as a percentage of the column total for seperate years. I'd like to show the share change between years. i.e. Brand A had 35% in 2017 and 25% in 2016 so it grew 10% from 2016 to 2017. Is it possible to make this calculation within the pivot table?

Solved by G. F. in 11 mins

Hello, could you please check if my pivot table is correct?
The task says: The value displayed in each cell (in the pivot table) should be the R&D spend for the corresponding country and year as percentage of GDP (i.e. taken from the 'Value' column in the row of the table on worksheet 'Research' where the country is in the 'LOCATION' column, the 'MEASURE' column has the value of 'PC_GDP', and the year is in the 'TIME' column). Thanks

Solved by D. H. in 16 mins