I have a sheet containing a bunch of PivotTables and graphs. The sheet has an area (B2:F2) where users can input filter criteria which when applied, will automatically filter the graphs displayed to the user.
For my data, there are literally tens of thousands of different...
Hi. I'm looking for the simplest way to analyze data stored in a tabular format in an excel sheet and make comparisons (text as well as value fields) using dates as columns.
To clarify, I have data for five days spanning over 20 different columns stored in an excel sheet. For each day, the date...
Background: I am "analyzing" data from a large table, for simplicity, I made a dumby excel spreadsheet. My data records races and which place the runner came in.
I have uploaded a photo as a visual aid.
My goal: To create a pivot table the accurately returns the win rate of the race...
I've found the below code to display overlapping pivot tables, which will look at every pivot table in the file and then it will pop up messages where the overlapping pivot tables are.
Can someone please update the code to make it so I can select the sheet that to code checks (I was...
question about pivot table FILTERS (see picture)
I erased my source data and my pivotable refreshes correctly as seen in the picture. this happens automatically as I am using a little VBA code in the source data to refresh my pivot tables automatically.
However, when you click...
I am confused as to which formula would be more appropriate for the below problem I am trying to resolve.
2020 monthly payment tab
I have a list of participants who give £3 per month and can select a product. They can stop participating at any time.
If product A, £1 is allocated to product...
I have 2 tables that I would like to look up the MAX date of when an item was marked down based on a specific date.
The first table is OH HISTORICAL. I would like to add a column or measure to find out what the discount was on a SKU. That is on or before the DATE.
So fi the item was...
Is it possible to create a PivotChart and PivotTable from the same information but display different information in each? I created a pie chart based on a PivotTable for an assignment, and when I moved the fields between areas like the legend and axis in the field list, it modified both the...
I have a pivot table where columns are counting values from the raw data. However, one of the values that is being counted is "" (aka just a blank / empty cell that is a result of a long IF statement). Is there a way to exclude this value from the count? I tried changing the formula in the...
I am creating a Glossary for a table with a lot of descriptions of certain activities. I want to be able to type in a cell a value and click the comand button to filter automatically instead of in the Pivot filter. I tried with this code but keep getting an error on the highlighted code...
My pivot table isn't refreshing when I tell it to.
This sheet has a connection to a SharePoint list.
This sheet has a table that is similar to Worksheet 1, but has additional columns for calculations. This table is then used as my source for the pivot table, which is...
I'm trying to write a macro to filter a pivot table based off a cell value.
I've adapted the code from this SO post: How to control Excel PIVOT tables from cell values with VBA
And this is mine currently
Sub Worksheet_SelectionChange(ByVal Target As Range)
'This line stops the worksheet...
I have a PivotTable with 5 thousand rows. For each row, I need to know their detailed positions. I can use the ShowDetail method, but it's not exactly what I want. It's created a new sheet for each row.
Is there a way to extract details of a row into a variable without creating...
I was given a sheet with a list of projects. It has a start date column and and end date column, and further information about the project (title, manager, budget) are in other separate columns. I have been trying to find a way to be able to select a month and year in a pivot table and have...
@MARK858 - Is it possible for you to help me on this please.
I have a Pivot table, where i need to Select Blank Column next to last row of Pivot table and Put Filter. I tried some coding but i am getting an error. Please help to rectify.
1. select Row from a Blank Column (Here it...