All Questions
29
questions with no upvoted or accepted answers
1
vote
0
answers
100
views
Excel Pivot Table - Calculated field returning "1" for all rows
Column C (Final Contracts) in My Pivot Table is a count of "Leads.LeadID" in My Data per User Name. Column I (Test) in My Pivot Table is a calculated field with the formula =count(Leads....
1
vote
0
answers
69
views
How do I extract design information from a pivot table in an external worksheet (properties) (Excel)
I am teaching a course in Microsoft Excel, using Excel 2019. As part of an exam in this course, I ask students to create pivot tables. I will then need to grade these exams.
Each student submits an ...
1
vote
1
answer
157
views
Pivot or Formula for Reverse Lookup
I am creating a list of features and the audiences that will be targeted for those features. Each stakeholder group (audience) is separate by a comma in the list. Now, if I want to create a pivot or ...
1
vote
1
answer
134
views
Combine none-unified data in excel based on row-id?
I have the need to combine different excel sheets of data into one single master file.
I have one master file with e-mail addresses and several excel-files from our CRM with data in different ...
1
vote
0
answers
61
views
Referencing a Pivot Table Value, reaching arbitrary limit?
I've come across a really strange case with a formula I'm using to reference a pivot table where I'd love your help.
Currently I have a report that is a simple table, as seen here:
The report draws ...
1
vote
1
answer
758
views
Advanced data consolidation in Excel
I need to Combine/Consolidate Data dynamically between over 20 separate Excel workbooks. The Column names and their relative position at the top row are the same. The positioning of each word under ...
1
vote
1
answer
2k
views
How to remove one column of a calculated item in Pivot?
I have two columns. One with data from this year and the other with data from previous year. I now have added a calculated item in Pivot to display the % delta of these two years. Now when doing this ...
1
vote
0
answers
242
views
Using getpivot in excel to create flexible reports based on user inputs
I am trying to make a report in Excel that sits on a very large set of data (set up in proper pivot form). I want to be able to select a value for a few fields (or select a value from 1 field but ...
0
votes
0
answers
21
views
Subtracting value from pivot table (only when the data is available)
The data in my pivot table changes every week. Sometimes the value for certain data will not be available during certain week and available in other week. For now I had to manually check the data and ...
0
votes
0
answers
79
views
Creating a technical excel data sheet to display efficient data
I am creating a table in excel that holds milestone achievement data with their respective amount. This table has multiple milestones that have only one amount, meaning that a set of milestone ...
0
votes
0
answers
77
views
Filterby multiple varying values in excel pivot table, without manually selecting
So I have a database connection that pulls data into a pivot table in excel, however I have a column called "Customer" I want to filter on, but i want to filter on specific customers (i want ...
0
votes
0
answers
20
views
PivotTable Conditional Formatting
I'm having trouble to understand how to apply PivotTable Conditional Formatting.
Homepage have a pivottable and a 'Date' filter.
Dataset have columns like:
Provider | Date | OC Number | Invoice Nº | ...
0
votes
1
answer
2k
views
How can I apply specific functions to pivot tables in Excel
I have some data that looks like this:
Item
Mass
CGx
CGy
CGz
Option
A123
10
4.2
0.1
0.5
AB01
C789
24
2.2
0.0
0.2
CD02
B456
12
3.8
0.0
0.7
AB01
D123
26
1.2
1.0
0.2
CD02
If I want to get the total ...
0
votes
1
answer
154
views
How can you format each row from a pivot table to display transposed with the headers repeating themselves?
From a pivot table, I am attempting to take each row of data and format it transposed with the headers from the pivot table present in each instance. Here is a link to a Google Sheet that has a sample ...
0
votes
0
answers
87
views
Date error in GetPivotData in MS Excel
I have a row with dates, 2018-01-01, 2018-02-01 ... 2020-12-01, that I want to reference to, from a GETPIVOTDATA formula.
I've managed to reference to another cells for Gross Profit, AM, Region, and ...