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,268
questions
0
votes
0
answers
21
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
2
answers
50
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
21
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
29
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
5
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
38
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 ...
- 223
0
votes
0
answers
42
views
SwiftUI store variety of generic functions for custom Table [closed]
Hello im still in my beginning of learning SwiftUI.
Currently I try to build a expense tracker myself for some more advanced practice.
For that reason I try to replicate a excel like pivot table for ...
- 1
0
votes
1
answer
44
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
57
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
17
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
45
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, ...
-2
votes
0
answers
63
views
Pivot query in SQL Server with nvarchar datatype [closed]
I have a table as below "table1"
Here value is of type "nvarchar(300)" but it contains both numeric string and string values.
ID
DocID
Name
Value
1
4
Alice
1234
1
4
Bob
false
2
...
- 5
-1
votes
0
answers
22
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
37
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