Hello, I'm trying to create a pivot table to show the values of different payroll codes by state. But the data that I have is in one row. I have a formula to split it into separate columns, but I can't get this into a pivot table without looking very ugly. I want it to say something similar to...
I am not sure if I am asking the right question, but I will try.
I am creating a pivot table with data similar to what is shown below:
ABCD1SystemIDNameAmount2Payroll5067John Smith III253Vendor5067Smith John254Payroll8855Debbie Brown305Vendor8855Brown R Debbie306Payroll3465Ned...
Hello,
I'm starting with columns B and C and my desired output is column A. Column A gives the values in column B and the number of times they occur (column C). My actual use case is much larger and it's tedious to do this manually. Hoping this is as straightforward as I feel like it should be...
Hello.
I am trying to group dates in a pivot table by pay period.
The pay periods extend from the 1st of each month to the 15th for the first half and then from the 16th to whatever the last day in the month is.
In the date grouping options I can only find the ability to group dates by the...
Hi,
I'm working on a big file having Power Query connections on another application.
Result is some Pivot Table having a lot of "yes/no" column with very long names in the header.
I want to changed the style of these header to always have the text vertically as displayed here :
I have an...
I'm not the greatest with macros and I generally use the record a macro and play around with it until it does what I want. I recorded creating a pivot table, placing it in an existing sheet and when I delete the pivot table and try to run the macro again to confirm it works, I am receiving a Run...
I'm trying to add the grand total row from my pivot table to my slicer. My slicer currently controls A lot of my charts and I want to be able to see the subtotals/grand totals of my certain field in my pivot table, displayed onto my chart. I cannot add a calculated item to my pivot table as I...
I am trying to create a pivot table that has a headcount of employees broken down by year and qtr. I am working on a dashboard and would like to include data from previous years (2016-current).
I have created a table with sample data that includes fictional names, hire date, termination date...
Hello - is there a way to have a protect sheet with a pivot table auto refresh when the source data is no protected? I am trying to export the pivot table (which is on a protected sheet) to a share folder access. The Pivot table is protect so each employee only sees the information they are...
Hello,
I have a Pivot Table that I created showing Year over Year (YOY) changes and I would like to sort this Pivot table to show Negative Values on top. I am showing years 2019,2020,2021, and 2022 and I would like to show the negative(YOY) for each year on top of the table. Is there a way to...
Hi Everyone
I need to filter my pivot table column label for Column "D1". I need this because everytime there is new item in D1, pivot table automatically clears all filters and starts showing all items.
Just to keep a record that which items I need to be seen, I created a list "PFilters" with...
Hi everyone,
I'm attempting to use VBA to change the filters on two pivot tables according to current month and quarter according to a broadcast calendar. The logic for the month filter was very simple, and my code works. However, our quarters are represented on this other pivot table by...
Hi all,
I'm struggling with formatting a pivot table based on some conditions.
My Pivot table has Countries as columns and Date as Rows (will attach a screenshot).
I need to fill the cells with Red if Blank, however for some of the countries (i.e Egypt,Ethiopia) if Blank need to fill with...
I just cannot work out how to do this so any help would be appreciated.
I have an account table (dim table): account name, start date, end date.
The user chooses a year using a disconnected 'year' slicer.
A measure [account status] calculates whether the account is 'active' or 'inactive'...
Hi,
I have this pivot table with ranked values of 1Yr and 5 Yr returns of various funds. I am trying to create a calculated field column with 50%*Rank1Y + 50% Rank 5Y. However, the calculated field doesn't let you choose the ranked values as the base for the formula. I was wondering if there is...
Currently I am using Microsoft Office 365 at work, version 2102 (Build 12801.21278)
Steps: Execute query> copy results and paste into new workbook>Insert Pivot table on all data>add columns and rows
When using a Pivot table in 365, if I attempt to double click a cell to show the records behind...
Hi all,
I currently have a list that looks like this (albeit much much much larger in reality):
I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...
christian røssel
conditional formatting
easy
excel
ezz
ezzzzzzzzzzzz
fast
format
formula
help
hlookup
index
indexmatch
jonas sværke
jyggalag
match
peter lim
pivottable
slicer
sverk
sverkieboy
sverknation
svorkieboy
svorknation
svorkster
svorktallica
vba
vba & code
vlookup
xlookup
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.