Stack Overflow
Stack Overflow

Questions tagged [excel-pivot]

48 questions
0
votes
0 answers

Update two filters in two pivot tables based on two cell values in Excel

I'm trying to filter two filters in two pivot tables based on two cells. The idea is that the user input information in two cells and these two pivots will update automatically (both filters). I'm using this code which work for updating only one…
Victoria Pastrán
  • 1
  • 1
0
votes
0 answers

Is there any way we can read Data from created Pivot Table using java code?

I am creating pivot table using poi and save it into another sheet but after that i want to read the data of recently created pivot table but somehow i could't get it For creating Pivot i am using: File file = new File(filepath); try…
Digant Joshi
  • 9
  • 2
0
votes
0 answers

multi tier pivot to handle tiers differently (SUM,MAX,SUM)

In my ODBC Excel File i have a pivot set up with 3 tiers: Bin,StockCode,Date. And NoOfDays as the value (always 1 per day/stockcode/bin combination) the 1st and 3rd tier should be summing totals and the 2nd tier should be reverting the Max. is this…
Steven de Beer
  • 108
  • 1
  • 14
0
votes
1 answer

Display Company if Company Sells Two Specific Products

I want to know which companies sell apples and oranges. My data set is as follows Name Product CompA Apple CompB Banana CompA Orange CompB Apple CompA Taco And I'd like the resulting pivot table (or really any reusable formula) to list…
canpan14
  • 1,181
  • 1
  • 14
  • 36
0
votes
1 answer

Excel VBA Macro Create Pivot Table with Dynamic Data Range: Source Data Range Error

I am new to VBA coding and trying to create an Excel macro which will create a pivot table based on a dynamic data range. I am using Excel 2016. The number of columns in the data will remain the same but the number of rows is dynamic. In my data…
Leigh
  • 43
  • 2
  • 10
0
votes
2 answers

In an excel pivot table, how do calculate percentages within a row of items within that row?

I am not trying to calculate a percentage as a percentage of the grand total. Rather I am trying to figure out what percentage of items within a specific row (or grouped category) meet a certain criterion. In this case, people who met the criterion…
CowboyBebop
  • 701
  • 7
  • 10
0
votes
0 answers

Exclude an option from Pivot table filter in Excel

I am having a pivot table and there are some filter on that pivot table. What we did is the data source of the pivot table is populated by java program and upon opening the excel file, the pivot table gets refreshed. Problem is that the filters on…
Muhammad Salman Farooq
  • 1,325
  • 9
  • 26
  • 54
0
votes
0 answers

What is the incorrect pivot table logic?

In an excel pivot table, I am looking to count all items created after the exit date for projects. None of the formulas have worked in the calculated field section.Several attempts listed below. Projects is the Row Label. The calculated fields…
t.mo
  • 253
  • 1
  • 4
  • 13
0
votes
2 answers

How to automate excel task

This is an example excel data I am using. I have to lookup address age and preferred location with 7-8 different file every morning. This is an example of the date which I receive to fill up. | Unique No.| Name | Address | Age | Preferred location…
Elisha Robert Joseph
  • 23
  • 1
  • 7
0
votes
1 answer

How to filter a Cubeset with a filter expression to calculate ytd Values

I want to filter a simple cubeset to calculate Year-To-Date Values in a Excel Pivot Datamodell There are ways I tried: with a From - To expression - this works but depends on the existens of the start and end month in the Datamodell with a filter…
Gerd
  • 138
  • 10
0
votes
1 answer

How can I get the ListObject object of a PivotTable?

This question was originally posted as part of an answer by Hugh Seagraves on a related question. He "wanted to refer to a list object (a table) on one worksheet that a pivot table on a different worksheet refers to," and did have a fairly good…
GlennFromIowa
  • 1,616
  • 1
  • 14
  • 19
0
votes
1 answer

Calculating the running average in a pivot table

I have a pivot table that has the following structure: Row fields are month (number 1 through 12) and values (revenue, sqft, rev_per_sqft which is a calculated field). I also show the Running Total in based on the month row. Now, this works…
Spurious
  • 1,903
  • 5
  • 27
  • 53
0
votes
2 answers

Filter 0-values in PivotTable

I have the following Excel spreadsheet: A B C Product Sent Quantity Returned Quantity 1 Product A 500 0 2 Product A 400 300 3 …
Michi
  • 4,663
  • 6
  • 33
  • 83
0
votes
1 answer

How to create calculated column in excel pivot table?

I have 3 columns in my excel sheet - ID, Version, Material No. for ex - and i want the pivot table to be like - How can i create the third calculated column because it involves two aggregation function to create it. I am looking for count of…
Prasoon Pandey
  • 99
  • 2
  • 4
  • 13
0
votes
0 answers

How can I create a Macro in excel that will always create a pivot table using raw data?

I am trying to automate some pieces of my reports for work. I want to have a macro that will take all the raw data in a worksheet and create/design the same pivot table every time. I have been able to create a normal table in this way by avoiding…
Cigaro
  • 51
  • 1
  • 7
1 2
3
4