pivot tabel

Hi All Is it possible to have a hyperlink in a pivot table?

I want to see the details of a selected cell in pivot table in a specific sheet not automated sheet , is that possible? selection.showdetails=true sheets("details")

Hello, I have a pivot table that shows me the return of few financial aplications ("ÍNDICE 1" and "ÍNDICE 2"), to do this I had to set this both collumn as a "sum" and changed the format to %. Everthing is ok... the problem is that I can´t sum this values on the total of the table/group, I...

I have a pivot table for sales orders. Each order had 1-10 lines with item description Sales order number quantity and unit price. It works fine but i would like to filter out any Sales Order with one line that has a 0 unit price. so if an order has ten lines, 9 have unit price values but...

Good Morning MrExcel! I am trying to get the syntax correct but I am not 100% sure the SumIF is the right command for what I am after or if it should be some very long if statement. I would greatly appreciate any insight you have: I think can do this with pivot charts to get the sum but I am...

Hi. I have never had an issue with this before, but for some reason when I put my data into a pivot table, where I have split the year in H1 & H2, and the corresponding quarters; I am seeing headers for Q3 & Q4 in H1. Which there should not be. There is nothing in my raw data, and the values in...

Hi, when I click in my pivot table it opens up a new sheet showing what is being counted in the cell I clicked. At first I thought it was only when I double-clicked or when i pressed something but it seems to happens more often. I'm not sure what I'm doing but it is very annoying. Anyone know...

Hi All, I am fairly new to VBA so if you could bare with me it would be much appreciated. What I would like to achieve is the ability to change the date filter in a whole range of pivot tables in multiple different worksheets in increments of months which take the form of "mmm-yy" EG. APR-15...

I'm trying to get a 52 week sales/inventory report to auto fill from a data dump in the form of a pivot table. The only problem is that if there is no sales data from a week then that week does not show up in my pivot table because of the lack of source data. For example if there were no sales...

Hi, I want to check the Colum A and Column E value and then collapse the Pivot table based on the values. myfile.Sheets(3).Select Dim dd As Range Dim ee As Range Dim ff As String For Each ee In myfile.Sheets(3).Range("E1:E20000") For Each dd In myfile.Sheets(3).Range("A1:A20000")...

I pull a report from an database for work that contains fundraising data. Column A is "First Name", Column B is "Last Name" Column C is "Email" and Column D is "Total Amount to date". I pull the report every week and each week there is added data for new entries and the total amount raised for...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> As you can see in the below table I want to add a field in the pivot table which automatically calculate the unique dates and show me the total count of these unique date as per...

Hi Guys, So I have List of products sold (to customers) and purchases (into the warehouse) I am now looking to summarise the data to see which products are slow moving. The fields I have are <tbody> Item Code Color Quantity Date Sold - Purchased Invoice Number Status issue Status...

Hi I have written a code which is working but it takes almost a minute to complete. Is it possible to optimize it? I've working in Excel 2007. Private Sub Worksheet_Change(ByVal Target As Range) Dim ws As Worksheet Dim wsmain As Worksheet Dim pt As PivotTable, ptf As Variant Dim pi As...

I need some advice on this pivot table/chart I have created. It’s my first attempt at a pivot table/chart, and I need it to accomplish two things. First: Easily compare data from test 1 to test 2 depending on a specific date. Second: a density graph where the change in density may be seen over a...

Hello, Is there a way to add a field in a pivot table, that is the remainder of the total? I see there is a running total, % of grand total. But is there a remainder of total? so the total is 100 row one has a running total of 10, so the remainder of total is 90 row two has a running total of...

HI there VBA Guru's I am using the following code to filter some Pivot Tables on a worksheet, however it takes sometime to run the marco, I would like to have a progress bar in the user form to show the progress of the macro. however I have not been able to insert a progress bar into the user...

Hi, I have a pivot table with a report field. I need to create a second pivot table based on the results of the first one. Meaning, I would like that the report filter of the second pivot table will be a list of the names that got filtered by the first pivot table. Meaning, the row fields in...