9,807 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
39
views
VBA Code to PivotFilter non zero values on Calculated field
Sub test2()
Dim pt As PivotTable
Dim pfRow As PivotField
Dim pfData As PivotField
Set pt = Sheet8.PivotTables("PivotTable1")
Set pfData = pt.PivotFields("Sum of ...
0
votes
1
answer
31
views
Aspose.Cells (.NET) (25.5.0): Error Logging
I was wondering is there a way to configure error logging for Aspose.Cells (.NET). The version I am using is, 25.5.0.
I am facing one issue with an excel workbook that has more than 10 excel sheets ...
0
votes
1
answer
107
views
How can I hide or collapse subtotal rows in an Excel PivotTable?
I'm wondering if this is possible, as with pivot tables in excel there is an option to expand or collapse all fields. If you try to record this in Automate, it says this action cannot be recorded. A ...
0
votes
2
answers
93
views
Calculated Field - Subtract two percentages for Percent Point Difference?
I am simply trying to add a calculated field to a pivot table, that subtracts two percentages. I'm trying to get the percent point difference between a "Name" average and "State" ...
0
votes
0
answers
40
views
Can I use FIND and IS-formulas in calculated pivot table fields?
I’d like to tally up rows that contain a certain text string in my PivotTable of studies.
This is the formula I use in the Insert Calculated Field dialog:
=ISNUMBER(FIND("🇬🇧",internalName))...
2
votes
0
answers
61
views
PowerPivot Measure - Average subgroup w/ Top N applied?
I am trying to calculate the difference of each "Row" value from that group's average from a group of two Top N filtered values.
I am able to successfully "pull down" the average ...
-1
votes
1
answer
86
views
How to pivot a Pandas dataframe into the desired format? [closed]
I have the following data in a dataframe:
Product t_Proj CFType1 CFType2 CFType3
0 Product1 0 270 193 130
1 Product1 1 233 197 362
2 Product1 2 130 278 375
3 Product1 3 ...
0
votes
1
answer
74
views
Pivot Table shows all rows regardless of value field selected
I am creating a schedule and capacity planner for the team I manage. On the data table along the top, I have a column for the task and who its assigned to, and then I have each day/date (Mon-Fri), for ...
0
votes
0
answers
42
views
Page unresponsive when loading 10k+ rows into AG Grid pivot table (with row/column virtualization enabled)
I’m new to AG Grid and trying to populate data into a pivot table in Angular.
I fetch the entire dataset in one API call (legacy, so I cannot change backend code).
In the frontend, users can drag ...
1
vote
1
answer
124
views
Show Difference in max/min values within Pivot Table?
I am trying to add a column in a Pivot Table, that shows the difference between the max and min values within a row/field.
Sample Data:
Name State Value
Albert MA 1
Albert ...
1
vote
2
answers
131
views
Pivot multiple columns [duplicate]
I have a vertical table that end users want converted to a horizontal table with some groupings. I'm writing this in SQL Server 2019.
My table looks like this:
PKID
cID
vID
vDate
1
2
81
1996年04月04日
2
...
0
votes
1
answer
83
views
Can I Create a Color Gradient Between Two Values in an Excel Pivot Table?
I need to conditionally format all values between 2 numbers in a pivot table using a color gradient to accentuate the scale of values between that range.
I'd like to not have any color for the rest of ...
0
votes
0
answers
21
views
Kendo React PivotGrid – Row headers and values not staying in sync while scrolling after customization
I’m using the KendoReact library to render a Pivot Table (PivotGrid) in my React project.I’ve customized the Pivot Table’s styles and layout according to my requirements.
Table is presnt On Two pages
...
2
votes
1
answer
135
views
Create a pivot table from a generally defined data set
I receive an Excel output from a program. The data set has the same number of columns and the headers begin in the same cell (A8), but the number of total rows will vary (not to exceed 100,000).
I'm ...
0
votes
1
answer
70
views
How can I perform an Oracle 2-dimensional for-clause pivot in Snowflake?
This pivot output section works fine in Oracle PL/SQL. It does not work in T-SQL.
I now need it to work in Snowflake SQL.
SELECT
*
FROM
(
SELECT
RACE, MNH_G, ...