Questions tagged [pivot-table]
A "pivot table" is a method of summarizing data in tabular form. Typically, these have a category column in the left hand side, and multiple summary columns to the right. Each different category will have its own row. Be sure to include the relevant language tag (python, excel, R, postgreSQL etc.) on your question.
pivot-table
8,270
questions
-2
votes
0
answers
10
views
How do i correct a text string that appears different in the pivot table? [closed]
A text string "Calibration" is appearing as "r" in my pivot table. I have tried to correct this but the r is still there.
I have tried to enter the details of the row that has the ...
0
votes
1
answer
30
views
Can I create a query on people attending workshops with a many to many relationship showing a matrix of how many workshops in common?
I'm using MS Access 2016
I have a visitor table, a workshop table and a linking attending table.
I would like to query this and get a matrix of numbers showing each one in relation to each other in a ...
0
votes
0
answers
27
views
How to pivot a Postgresql table with a dynamic row count
I have a system which monitors the climate in buildings. There are are sensors for temperature and for humidity.
I have a table which contains the latest value of each sensor that exists in the system....
- 1
-1
votes
1
answer
25
views
Using Vlookup in excel vba casuing update value even for that existing sheet
I am new in learning excel VBA but I am facing a issue in a line of a code where I am using vlookup lookup value in is " collection data" and lookup array in "Pivot" sheet. But ...
- 21
0
votes
1
answer
57
views
VBA code to exclude items in filter on a pivot table filter
I am relatively new to VBA. I can't find a code to exclude items in a filter on a pivot table filter. I am currently trying this but I get always get an error with the filter. For this one I get an ...
0
votes
2
answers
24
views
Create a measure that ignores table filtering and aggregates to a higher level in pivot table - DAX/Power Pivot
I am attempting to rebuild a backend for an excel dashboard with power pivot and need to create a series of columns that give a category level total per personal ID. This means the sum of that ...
- 1
2
votes
1
answer
31
views
Pandas Convert Headers to DOW and Count?
I have a CSV file which currently has a format
Unnamed
1/1/24
1/2/24
etc
Person 1
NaN
Assignment1
etc
Person 1
NaN
Assignment2
etc
Person 2
Assignment 1
NaN
etc
Currently what I am doing is as ...
- 57
0
votes
0
answers
7
views
Creating a Comparative Performance Analysis Table with Filters in AWS QuickSight
I am a beginner in using Amazon QuickSight, and I have a dataset containing information about tasks performed by groups, including a performance score for each task. My goal is to create a table that ...
- 13
0
votes
0
answers
59
views
Dependent Pivot Drop Downs
I am hoping someone can help. My search thus far has yielded no results, and I refuse to think this hasn't been released yet.
I have a Pivot of an extremely large set of data. In the filters is a ...
- 235
0
votes
1
answer
45
views
Use Power Query to consolidate rows (like Pivot Table, but maybe something else)
(Very simplified) I have data like this that I get after a complex series of steps in Power Query.
Previously, I used a Macro to create a Pivot table like so:
But I was hoping to get away from that. ...
- 39
-1
votes
1
answer
60
views
Need help in Pivot table or Formatting the data
I have a scenario where I have the list of promotions by each job level by Month. In December, the promotion receivership % is 6.6% and in June 2.5% however when I include both I was expecting 9.1%. ...
0
votes
0
answers
19
views
Calculated field in a pivot table based on power query
I have a sheet with Planned sales data. I have a second sheet with Actual Sales data.
I combined the two sheets using Power Query,
I then created a pivot table but as the data is coming from a model i ...
1
vote
2
answers
52
views
How to categorize table columns by table results and return header as results
I would like to create a table that uses data from another, where the results become the column headers (static) and returns the headers from table 1. As there will be duplicate results in table 1, ...
-1
votes
0
answers
23
views
Filter the number of values in a pivot table [duplicate]
I have a table in the below format:
where the category stretches from X1 to X5 and Time repeats from 1 to 9. s1 to s5 are having independent data entries.
When I convert it into pivot table, I get ...
- 47
0
votes
1
answer
43
views
How to PIVOT data in snowflake by using ANY without having quotes for 'Column_Names'
How to PIVOT data in snowflake by using ANY without having quotes for 'Column_Names'.
CREATE OR REPLACE TEMPORARY TABLE quarterly_sales(
empid INT,
amount INT,
quarter TEXT)
AS SELECT * FROM ...
- 17