All Questions
Tagged with microsoft-excel-2007 pivot-table
56
questions
0
votes
1
answer
9
views
How to add a cell reference to Date Filter in Excel Pivot Tables
I have a date in cell C3, I want the Pivot table to only show expenses from that day. I tried entering the cell reference in this field to create a custom filter but it does not work. I also tried ...
0
votes
1
answer
608
views
Get count of categories present in a column in separate columns in pivot table in excel
I have a pivot table which looks like
Now I want to get count of each category in State column in a separate column. Something like this.
I tried creating a pivot table, but the format is not what I ...
- 105
0
votes
1
answer
109
views
Update table starting from today's date in Excel
I have an excel worksheet similar to the following -
Col A - Clients name,
Col B - Col D - Cient's info such as address, Phone no etc and
Col E - Date of next meeting.
I want to create a table ...
- 115
0
votes
1
answer
2k
views
In an excel pivot table, how can I only select rows that has a particular value in it?
Here's the pivot table I have :
Mat Cust A B C D E F G H I J
1 P 0% 39% 18% 19% 0% 0% 0% 24% 0% 0%
2 Q 0% 52% 21% 19% 0% 0% 0% 7% 0% 0%
3 ...
0
votes
1
answer
1k
views
Pivot table with multiple, non hierarchical, columns
Let's say my source data looks like this:
Brand Model Color Region Sales
---------------------------------------
Ford Focus Black N/A 23
Ford Focus White N/A 2
...
- 970
0
votes
1
answer
37k
views
Excel: How to Group Dates Per Week in Line Graph
I have data that looks like this:
Actual End Date ----CP
2016-04-22------------4
2016-04-26------------3
2016-04-26------------9
2016-04-22------------7
2016-04-26------------6
2016-04-26-------...
1
vote
1
answer
6k
views
How to keep pivot table from expanding into occupied rows and columns
I have a pivot table with other calculations surrounding it. My issue is that if more row/column groupings are added to the pivot table, it extends and reaches the cells where these other calculations ...
- 11
2
votes
1
answer
498
views
How can I use Excel to monitor my payable?
Here's what I wanted to happen, I have five columns
Supplier Amount Payment Supplier1 Supplier2
When I have a receipt of my payable, I'll encode the name of supplier and it's amount. When ...
- 23
0
votes
2
answers
334
views
Month by Month Pivot Table
I have a list of dates and data that go back a year. In Excel, I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly ...
1
vote
0
answers
1k
views
Filtering values on Excel Pivot Chart
I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold.
For this, I click PivotChart filter and see that filter may ...
0
votes
1
answer
3k
views
Filter a pivot table based on the values in specific columns
I have a pivot table where there are multiple column labels:
group
subgroup
subsubgroup
status
The last label, status, has only two possible values, ACTIVE and DORMANT. I need to show only those ...
- 143
0
votes
2
answers
12k
views
How to get count in pivot table that does NOT count duplicate entries
I am setting up a pivot table, and I would like for it to give me the count of the number of unique combinations of two fields, not just the total count. That is, each combination should only be ...
2
votes
1
answer
13k
views
Pivot table with two headers in MS Excel
I'd soo appreciate if someone could help.
My initial table looks like this:
Brand Period_1 Period_1 Period_2 Period_2
------------------------------------------------------
...
- 123
12
votes
3
answers
173k
views
Have Pivot Chart show only some columns in pivot table
I have a data table. In the table I have some dollar amounts. I also have formulas that use lookups to group these dollar amounts into groups in the data itself.
I then have a pivot table where ...
- 321
-1
votes
2
answers
1k
views
Power Pivot - Average time per item
I'm trying to calculate on average, how long it takes to make each item.
Here is the data table:
Date Item Quantity Operator
01/01/2014 Item1 3 John
01/01/2014 Item2 5 ...
- 1