pivot table

Hi all! I have a table that includes contract purchases (+$) and charges (-$). Looking for advice on what kind of helper columns, formulas or calculations I need to add to the table to give me a report that shows what the opening and closing, remainder balance is for each month... I have...

Hello Friends, I have a workbook and there is 6 question and i'm really confused abouth than so if anyone can help to ans those question I will very helpfull and appreciate your help. File Link Thank you.

Hello, I am attempting to create a pivot table that would have Conditional formatting. I can add conditional formatting to the table as a whole, but I need separate rules for each column and excel just isn't doing it. I have done all the research I could think of to figure this out on my own...

Hello, we have been using a pivot table to create interval level data for a report. The user selects which historical weeks should be considered and what activates should be included in the pivot table options. is there a way to have the selected filters published in list form? Essentially, I...

I am trying to sort pivot table fields based on sort order given in the table, however system seems to be ignoring sort order. Requesting community members to guide how to achieve required sort order in the pivot table. Sheets in the file: 1. TB- Trial Balance having GL code and values 2...

Hi all, I am fairly new to Power Pivot. I am having some trouble understanding filtering between related tables. I have my main table "Demographics", in which "Index" is Unique so: Index Role 1 Engineer 2 Engineer 3 Manager...

Hi all, I have this data, where all the rows with "Response" as "Distributed" have only blank cells next to it: RoleExperienceResponseIndexDistributed1Engineer≤ 10 YearsComplete2Engineer≤ 10 YearsComplete3Technician> 10 YearsComplete4Technician≤ 10 YearsComplete5Engineer≤ 10...

Hello! Instruction say I have to put the 'Total Price' (which is a calculated field) onto the 'Values' of the Pivot Table. The formula I used for the 'Total Price' is "=UnitPrice*Quantity". I manually Calculated the "Los Angeles - Whole Wheat" (293.16) as well as the "Total Whole Wheat on the...

Hi All, I am trying to do the following, please let me know if this is possible: I have a "Value Field" called Count of Value_Proficiency which simply counts the occurrence of each Row Label I would like to create a new "Measure" having Max of Count of Value_Proficiency repeated for all Row...

Hello, I have a question on pivot charts. Let's say there is a pivot table with 3 columns. 1st:Issue name, 2nd:opened date, 3rd: closed date. The column with closed dates contains blank cells. I want to make a chart with 2 lines. X axis with dates and Y axis with number of issues. Each line...

I am trying to write some VBA to loop through a PivotTable, and I am struggling with the appropriate objects and names. My PivotTable has a handful of filters (the code needs to be able to accomodate a changing number here), 7 row fields (this will be unchanging), and one column field (the one...

Hello, i'm looking for help with creating a loop for creating pivot tables and also some help in defining how graphs are arranged. The workbook i have works ok, however i am manually creating a pivot table for each Toy category in the data table. When more Toy categories are added i would like...

Hi All, I recorded a macro to see if there was a way after I inserted 3 slicers, to select report connections for each of the slicers to select pivot table without having to right click and select report connections for each slicer. This is the below macro code from the recorder: Sub...

I am trying to use the getpivotdata formula to use the data from a larger pivot table. If I use the formula that excel gives me when I put =and click the value i need it looks like this "=GETPIVOTDATA("[Measures].[Count of Training Start]",$A$3,"[Table4].[Manager]","[Table4].[Manager].&[C...

I formatted row labels (see image below) as number in original table and checked with isnumber. However here in pivot table they behave like text. I want to sort them descending.

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