pivot tables

I'm working with some data Where I have a branch, clients in a branch and products with that client. I've managed to get the values in a pivot from measures at product level provided I filter on a client. A soon as clear the client filter all the values become incorrect. Ideally I want to...

I have multiple pivot tables that are part of a data model that I want to unprotect, refresh, and reprotect. Below is the VBA Code I have so far. It isn't working. Excel gives me a message "That command cannot be performed while a protected sheet contains another PivotTable report based on...

Hi all, As far as I know, Pivot Tables are incredibly useful. However, I have never had the chance to actually use them in my work or private life. Does anybody have some simple examples where pivot tables are useful? And what do you guys use them for? Thank you! Kind regards, Jyggalag

Hi all, Using Excel 365. I would like to use a Named Range that contains a Tax_Rate in a calculated field This way, users can easily change the rate on an Input Sheet if the rate should change. It seems the calculated field does not recognized the Named Range. What are some other options...

We ship parts to multiple locations. I'm trying to see parts by a specific location (easy), and at the same time see the other locations a specific part ships to. So far all my efforts have been self-defeating because of the initial filtering by location. An easy example: Part Number...

I have tried solving the problem Q1 and Q2 and I am getting errors. I have attached the images with this. PS- Q1 and Q2 are the questions. Tab1, Tab2 and Tab3 is the data I have to work on. How do I got about the same? Please help me out. Thanks!

Hello, I'm struggling with a combined table result issue as follows and I'm hoping someone can help. I've got 5 seperate sheets, all with named tables that are exactly the same format - the tables refer to customer orders that contain the same data - so order live/dead, order number, part...

Hello everybody, i have a chart (created from a pivot table) and i want the user to be able to use the filter on the chart but to NOT be able to edit, copy or move the chart. Is this possible??

I have been trying to figure this out all day: I am building a dashboard, and I have everything in a summary tab (in a table) to pull for pivots. The dates do not seem to be recognized as dates when I try to use a pivot to group by date. I have tried text to columns, and formatting cells. I...

Have you ever wanted to put Text into the fields in a Pivot Table instead of Values. Well, I found this link where Bill Jelen shows you how using Power Pivot at the site Strategic Finance. Fairly easy to follow. https://sfmagazine.com/post-entry/ju...a-pivot-table/

The question I have is why this code simply toggles between showing and hiding the Sales Date pivot field. It’s only supposed to hide the Sales Date pivot field when the cell M11’s value is “Weeks” but it seems like it’s ignoring this second condition of the if statement. M11 is a pivot row...

I have been struggling to create a pivot table using the following piece of VBA code, but I cannot find the error. I assigned a watch window to PT2, and I noticed after I set PT2 equal to the PivotCache, PTCache2, PT2 still appears with a value of nothing. The With Block does not work because...

Hi I've created a worksheet which has two pivot tables drawing from the same source-data. So the pivot tables - both - are not reflecting the correct data. So I clicked on 'show details' - which of course - brings up another sheet showing the specific filtered data being used. The filtered data...

I am looking to add a measure for my pivot table that will do a simple pass fail rate calculation. The calculation is =pass/sum(pass, fail) how do I translate that into pivot table language? There are 4 basic criteria I am working with. Inspection ID, Date/time, Eval Area, and Rate Status. The...

I have spreadsheet with the performance data of 50 search engine search terms across multiple ad campaigns in Google and Bing. For each of the data columns below, I would like to create a formula I would use to aggregate the data in a pivot table: 1) Impressions 2) Clicks 3) Click-Through Rate...

Hello, I have a table with many rows and columns. Each row represents a course a user still needs to complete. The row will have the user's name, and a bunch of other columns, including a "People.Temporary" column which indicates if the user is a temporary employee. If the user has more than...

I have looked and do not find a solution to acquire one column's data, insert it into a new sheet. Then acquire another column's data from a different sheet and enter that into the same column that the first column's data was inserted. This way the data from two columns, each from a different...

Hey Team, I've developed a dashboard but have come across one error and I am hoping someone out there can help me! By using VBA code, I have columns which allows for multiple items in a drop-down list e.g. column A has the option to select Apple, Orange, Banana. Is there a way to produce a...

I am trying to have texts in a value field in a pivot table, and my understanding is that creating a Measure (concatenating the text) is the best way to do so. However, I am unable to create a measure when I am in the Pivot Table, as even after I select "Add Data to Data Model" when creating the...

Hi I have a pivot table on sheet 1 and would like to paste values to the next empty row on sheet2. I need a macro that will select everything but the header on line 1 and grab the data on the table and paste to the next empty line. Thanks. This is what i have so far, but it writes over the...