Stack Overflow
Stack Overflow

Questions tagged [excel-pivot]

48 questions
2
votes
1 answer

How to solve comerror: PivotFields method of PivotTable class failed?

I'm trying to refresh a pivot table in excel and update existing filters using python's win32com. However, I'm hitting the error of: com_error: (-214735267, 'Exception occured.', (0, 'Microsoft Excel', 'PivotFields method of PivotTable class…
John peter
  • 144
  • 1
  • 11
2
votes
0 answers

MDM Cube browsing Fast vs Excel pivot being too slow

I have a MDM cube with fact having just 84K records. Simple STAR schema structure. All regular relationships and no calculations or KPIs. While trying to browse the cube by pulling 15-20 attributes from various dimensions with no filters applied,…
Amit Singh
  • 21
  • 1
2
votes
0 answers

C# Refreshing Pivotcache or RefreshTable is not refreshing the excel pivot table

I have a sheet that I update in C#. There is a pivot table using this sheet which needs to be refreshed. I am trying to refresh this Pivot table using VS 2015 and C#. I am doing the below and it doesn't seem to refresh the Pivot table. I am able to…
user728148
  • 159
  • 1
  • 6
  • 19
1
vote
2 answers

Summary pivot table from matrix data

I have an excel file that contains a table formatted in this way (the example here below is just notional): Table 1 Column A Column B Column C Group A Option 12 Option 33 Group B Option 11 Option 15 Group B Option 12 Option 13 Group…
FancyPants
  • 73
  • 1
  • 6
1
vote
0 answers

Transferring Pivot Tables & Charts without Source Data

I need to send the excel workbook tabs from "Combined" to "PPA HQ" that contain pivot tables and graphs, without the source data. Is it possible to do that? I would like to keep the the tabs "Combined" to "PPA HQ" in the same workbook and same…
emald
  • 35
  • 4
1
vote
1 answer

Can I get the name of a single Field in the "Values" quadrant of PivotTable?

Preface: I am trying to build a macro that relies on no absolute references. Problem: Part of my macro needs the name of the field in the "Values" quadrant of the active PivotTable. The field name will change so I cannot hard code it into my macro.…
Logan Price
  • 73
  • 7
1
vote
0 answers

openpyxl - update xslx sheet and preserve pivot table

I am working on an xlsx with two sheets: the first one containing raw data and the second one containing a pivot table. I cannot manage to modify the data-sheet without getting the pivot one in plain text: I've seen many people have the same issue…
Ema_py
  • 11
  • 3
1
vote
1 answer

Register Event for automatically generated Worksheet in Excel

When the user doubleclick on a cell in a Pivot-Table, Excel generates a new Worksheet with the Details. That is perfect. I am searching for a possibility to register a VBA-Event in this new Worksheet. I want register a function for the Event…
BennoDual
  • 5,865
  • 15
  • 67
  • 153
1
vote
1 answer

Default date aggregation for Excel

What is the default behavior of adding a date, time, or datetime into an Excel pivot row/column? I have seen it sometimes add it as the "raw value", sometimes it will add it as a Year > Query > Value, and other times (?) perhaps in between. For…
David542
  • 104,438
  • 178
  • 489
  • 842
1
vote
1 answer

Apply a fixed value dynamically to a calculated field in a pivot table

I have the following Excel spreadsheet: In Column C you can see the sales from the products in Column B. In Column A you can find the corresponding brand to each of the products in Column B. Based on these datas I created the following…
Michi
  • 4,663
  • 6
  • 33
  • 83
1
vote
2 answers

Excel Pivot Table IF Statement

What I'm trying to do is, I have on the sheet of multiple dates (report dates) in column A and a transition date column in column E. From B - D I have numbers in each column corresponding with actual price then fees. What happens in this is sheet is…
Maykid
  • 497
  • 3
  • 7
  • 17
1
vote
3 answers

Sorting an Excel Pivot Table by a calculated field

I have the following Excel spreadsheet: A B C D 1 Product Category Sale Margin 2 Product A Apparel 500 45% 3 Product A Apparel 400 …
Michi
  • 4,663
  • 6
  • 33
  • 83
1
vote
1 answer

5 tables in 1 pivot table relationship

I have 5 tables (each table has a Date column) I want to make a relationship between all the dates of all the tables in the pivot table to do some data analysis. But unfortunately, the relationship is between 2 columns only However, i tried to make…
Dawoud
  • 13
  • 3
1
vote
1 answer

Issues using mdx generated from PivotTable

I recently used excel to connect to analysis services and generate a mdx code that was used to query the cube. The code is shown below. The code was also verified using sql profiler. However when I go to analysis services and browse the cube and put…
Mutai
  • 125
  • 1
  • 1
  • 9
0
votes
0 answers

Analyze Power Bi in Excel - aggregated measures "cannot be placed in that area of the report" into Excel values

I have a PBi report published. Within the report I've created a summarizedcolumns table that the user can Excel analyze (instead of hiding all the protected data columns). Per Microsoft I have ensured the columns to be used as values are set with…
T. Hughes
  • 53
  • 6
1
2 3 4