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 ...
6
votes
1
answer
31k
views
Working with Averages in Pivot Table (Calculated Field)
I have the following data :
customer_id customer_name id date contract_value costs profit_extra_work
200027 Company A 00.161.559 08/07/2015 499.5 50.55 0
...
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 ...
1
vote
2
answers
1k
views
Remove column names from formulae (Convert into regular cell coordinates without sheet names)
I have a defined table of several rows and columns containing data and formulae. Some of the columns' cells' formulae are:
=[@[Weight]]*1000
Where 'Weight' is the name of a column heading.
I want ...
4
votes
1
answer
32k
views
How can I get the number of rows in an Excel pivot table for use outside the pivot table?
I have a pivot table in Excel of the form:
Country Server Status
Australia AU1 1
AU2 1
AU3 4
New Zealand NZ1 4
NZ2 ...
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 ...