Skip to main content
9,809 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
23 views

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 ...
darthAJ's user avatar
  • 1
0 votes
1 answer
84 views

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 ...
Deb's user avatar
  • 3
1 vote
2 answers
87 views

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" ...
BruceWayne's user avatar
  • 23.5k
0 votes
0 answers
38 views

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))...
Andy's user avatar
  • 6,368
2 votes
0 answers
60 views

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 ...
BruceWayne's user avatar
  • 23.5k
-1 votes
1 answer
84 views

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 ...
DC00107's user avatar
  • 3
0 votes
1 answer
71 views

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 ...
help's user avatar
  • 1
0 votes
0 answers
41 views

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 ...
Tracy's user avatar
  • 3
1 vote
1 answer
108 views

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 ...
BruceWayne's user avatar
  • 23.5k
1 vote
2 answers
128 views

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 ...
Steve's user avatar
  • 23
0 votes
1 answer
68 views

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 ...
kxmoosekx's user avatar
  • 21
0 votes
0 answers
19 views

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 ...
Megha's user avatar
  • 1
2 votes
1 answer
130 views

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 ...
Greg's user avatar
  • 21
0 votes
1 answer
66 views

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, ...
Timothy Dooling's user avatar
  • 522
1 vote
0 answers
92 views

I have VBA code, coded by someone else, to filter an OLAP pivot table. I want to filter for multiple trade dates rather than one. I am aware that .CurrentPageName doesn't allow for multiple values. ...
Originalcntent's user avatar
  • 11
1 vote
1 answer
79 views

I'm new to DAX and am trying a formula to calculate the Median Absolute Deviation. The source is this Reddit post. However, I get an incomplete or invalid formula error (please see screenshot below): ...
Manish's user avatar
  • 1,806
1 vote
1 answer
79 views

I have a pivot that I want to NOT re-sort after changing a filter. This would replicate in code the effect of right clicking the sorted field's drop-down arrow and going to More Options and unchecking ...
Bluebonnet's user avatar
  • 41
0 votes
2 answers
108 views

Consider the following PivotTable in Excel: As you can see the Sum of CalcRevenue per month makes no sense. Excel apparantly FIRST sums the grouped rows and THEN multiplies them. Any resolution to get ...
Charles de M.'s user avatar
  • 715
0 votes
0 answers
111 views

I have been trying to code a VBA bulk filtering that works on different PivotTables formats, which includes both the usual ones and those ones with OLAP. The point is that I am stuck in figuring out ...
Fernando's user avatar
  • 1
0 votes
1 answer
105 views

I'm updating an excel spreadsheet which has VBA codeing in the background. The changes I have made to a table means the vba code now doesn't work correctly. The original code is: Public Sub ...
Sarah's user avatar
  • 1
0 votes
0 answers
39 views

AI is driving me into a dead end. I can't solve the problem. I have data in Power Pivot in the following format: I need to create a report that will track the dynamics of changes in reasons. I want ...
Катя Панишова's user avatar
  • 1
-1 votes
1 answer
168 views

I want to create a table in Microsoft Excel that includes multiple subcategories. The categories are outlined below. Each column, from A to H, represents a level in the category hierarchy—starting ...
Sagnik Bagchi's user avatar
  • 11
0 votes
0 answers
133 views

I've been searching around online for ages and I see tons of people posting that the math going into a pivot table is wrong, but I can't find anyone with the problem that I'm having: The data coming ...
Loren Infeld's user avatar
  • 1
1 vote
0 answers
39 views

I have 3 types of entities ( which can have multiple values ): A, B and C. Now, A is sending requests to B and B sends requests over to C. However, when A acts a sender, B is the recipient and when B ...
Devanjan Banerjee's user avatar
  • 11
0 votes
0 answers
63 views

I have a list of objects with four properties: Week, Year, Amount (EUR), and M2 (square meters), which I need to display using the PivotGrid. Here is the configuration I’m using: Year is placed in ...
MUMBUÇOĞLU's user avatar
  • 261
0 votes
0 answers
48 views

I am trying to create a c# application that takes csv input and converts the data into a Pivot table based on the report type that we are ingesting the data for. The creation of the table is fine, ...
CyberRulez's user avatar
  • 36
3 votes
1 answer
71 views

New to VBA and I've been struggling to find the right data source for my Pivot table in Excel. The data source should be coming from column "B" in sheet "Monthly". Any tips on how ...
Light3n's user avatar
  • 45
0 votes
1 answer
101 views

I have a recurring problem which I have been addressing using a messy approach of multiple passes of pivot_wider and rbinding the results together. This seems inelegant, does anyone have a single ...
Peter's user avatar
  • 152
0 votes
1 answer
108 views

I have a pivot table that returns the min of a date per category . Can I have a calculated field that works like this: date - Today I tried a calculated field but couldn't select the min of date to ...
Islands_CLF's user avatar
  • 3
0 votes
0 answers
27 views

I have a MYSQL (very early release) query which returns the current location of assets (by querying three tables, zonenames, asset names and logs (logs shows the last know location timestamp of the ...
Ralph's user avatar
  • 205
0 votes
0 answers
42 views

Need your support to connect 2 workbooks naming " Custom view" and " Finance pivot View" as attached. Every month our finance team publishes the pivot table as depicted in "...
rajendra kodavaty's user avatar
  • 39
0 votes
0 answers
76 views

I have a pivot table of data in column A:L. In the first column to the right of the pivot table column [13] or "M" I have some comments written that correspond to that row of data. As the ...
Brian Reim's user avatar
  • 1
0 votes
0 answers
44 views

I have a Pivot chart as shown below. It has Scenario_Model and Gx.Region under x-Axis (Categories). I want to add a clear visible distinctive line to differentiate the different scenarios. I have done ...
hbstha123's user avatar
  • 1,810
1 vote
3 answers
113 views

I have dataset (simplified) that looks like the example below Score First Language FLPecentage FLScore Second Language SLPercentage SLScore Year Quarter 120 Java 90 108 C# 10 12 2024 4 200 C# 75 150 C+...
Stephan's user avatar
  • 665
0 votes
0 answers
57 views

My excel file has a sheet with 5 "global" slicers that I want to apply to all the pivot tables in the other sheets Each other sheet has its own "local" slicers which are connected ...
RedKnight91's user avatar
  • 400
0 votes
0 answers
27 views

I have been struggling to get my crossTab to group by "Month Year". I read that SimpleDateFormat is outdated. My dataset is using language domain. The coding is html style and lots of ...
Edward's user avatar
  • 896
0 votes
0 answers
89 views

I've created a pivot table using this data (This is just a snippet of a larger sheet): The idea behind this pivot table is to count how many people have received upgrades (the first column) per ...
Con's user avatar
  • 11
0 votes
0 answers
51 views

I have a data table and want to create a pivot table off it (top part of image) with a variance field Calculated as the NPV difference (change/movement) between Period D and F (middle part). I have ...
Dasal Kalubowila's user avatar
  • 145
0 votes
1 answer
80 views

I'm using the pivot table wth the structure below: I want to add a filter that only displays the letter groups that have more than one subgroup, so in this example, A, C, D, & E would all be ...
Roger99's user avatar
  • 1,012
0 votes
0 answers
20 views

I am following the code (chapter_08_reshaping_and_pivoting) from following website. https://github.com/paskhaver/pandas-in-action import pandas as pd pd.read_csv('sales_by_employee.csv').head() sales =...
MCPMH's user avatar
  • 403
-2 votes
1 answer
45 views

I work with survey data which I get from a contractor (it's weighted). But I sometimes need different cross tabs from those they provide me. I don't currently have any budget for any software to do it,...
BeardedShrimper's user avatar
  • 3
0 votes
1 answer
55 views

I have a data frame that looks like this: ID Email Name Company TripIdentifier Date1 Campsite1 NumberOfAnimals1 Date2 Campsite2 NumberOfAnimals2 1 1 [email protected] ...
R Beginner's user avatar
  • 1
0 votes
4 answers
86 views

I have data that is denormalized and I want to grab the the column for each person where there is a value in the max column. If there is a value for Jump2 there will be a value for Jump1; there will ...
Khanh Hua's user avatar
  • 11
0 votes
1 answer
67 views

I am trying to find an easy way using two excel tables with a pivot table on the first table to apply a commission percentage, where a client could pay out commission to multiple Reps. New data would ...
Edward's user avatar
  • 896
1 vote
1 answer
97 views

I am trying to insert a slicer to filter a pivot table using Office Scripts. However, I always receive a run time error when using the below code. The objects passed to the add method seem to exist, ...
Seldon's user avatar
  • 25
0 votes
0 answers
80 views

I have a many-to-many relationship between roles and permissions in my application. I already have the pivot table with columns role_id, permission_id, and a new column access_type with an enum that ...
Fazry Javier's user avatar
  • 1
1 vote
1 answer
71 views

I am trying to create a cross tabulation of social category and accessibility to a policy, controlling for Region. Example of data I have: ID Region SoCat PolAcc 1 Urban Poor Yes 2 Urban MidCls Yes 3 ...
mam_k's user avatar
  • 11
-4 votes
1 answer
104 views

I am trying to query a table in Google Sheets with a pivot to achieve what is in the screenshots below. My formula just keeps returning errors, and I have tried various combinations without success. =...
E_T's user avatar
  • 1
0 votes
2 answers
51 views

I am working on a Crystal Report and facing an issue. I cannot make every cell in the categories have multiple activities vertically , so each category needs to have multiple activities with row spans....
ahmed salah abd elaziz elbarba's user avatar
  • 37
0 votes
1 answer
25 views

I would like to create a pivot table with a summary of some sales orders. The sales orders include lists of hardware and software license items. The software licenses have "end dates" as ...
JetSetJim's user avatar
  • 78

1
2 3 4 5
…
197