All Questions
72
questions
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 ...
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....
0
votes
1
answer
319
views
How to un-pivot data in a table on Excel for Mac
I've read the suggested results pertaining to un-pivoting a table using the method from a Jon Walkenbach article, but I'm on a Mac, and can't get the desired result.
My scenario is exactly the same as ...
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 ...
1
vote
1
answer
516
views
Create scatter plot using two arrays of data in Excel [duplicate]
I'm an aspiring eSports rookie who has been tracking his training progress for some time now. I have two tables in an Excel worksheet: The first is Accuracy, with rows being date and columns being ...
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º | ...
1
vote
1
answer
139
views
GetPivot formula is not taking cell reference into account
I'm trying to deduct sales on each date from the stock. That means if I sold 10 units on 7th July from the stock of 100 units, I'd have 90 units left, and If I sell 20 units on 8th July the ...
0
votes
1
answer
48
views
custom per-category formulae over summarised rows
I'm trying to figure out some pivot table magic here, where I can have the top-level row-field be a custom formula for each category. So, for example, with data like this:
Edit: Providing in CSV ...
0
votes
1
answer
112
views
Reusing row values in pivot table
From a list of contracts I want to learn which month the invoices are due. The invoice frequency is different per contract, ranging from monthly (12x) to quarterly (4x) and yearly (1x). Also the start ...
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
197
views
How to conditionally merge tables in Excel
I have two tables of data in Excel that were exported from our HR system. One contains estimated/planned workhours, the other contains actual worked hours. Each line has a date, hours worked, and the ...
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 ...
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
1
answer
231
views
how do I fix these issues Pivot tables and/or the IF formula in Excel 365?
I am managing a waitlist spreadsheet with many tab that requires monthly data to be extracted e.g. number of referrals, wait from assessment to intervention in wks etc. People move from the referral ...