showdetail

Hello everyone, 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...

Hello, I need assistance, please! I have an excel document that has multiple worksheets. On one of the worksheets, I have multiple pivot tables that are manually created, based on the data being used. The primary use for this document is to take a "Big Data" file and provide the "customer"...

Hello, I need assistance, please! I have an excel document that has multiple worksheets. On one of the worksheets, I have multiple pivot tables that are manually created, based on the data being used. The primary use for this document is to take a "Big Data" file and provide the "customer"...

Hello All, I am working on a project that will Group/Ungroup specific columns based on a loop. for ease of maintenance I have created Named Ranges for the groupings to Expand or collapse the groupings based on a variable in a list. Here is the list Excel WorkbookABC1DivisionsNamed...

I can't seem to figure out how to determine which rows (or columns) in a PivotTable are collapsed/expanded. PivotItem.ShowDetail works for some tables but as I understand it DrilledDown is the equivalent for the other types of tables - "data model/OLAP tables". However, while setting the...

Hi, I'm trying to test whether a group of columns is hidden or unhidden by grouping, if I was to use 2 statements such as Columns(2).ShowDetail = True and Columns(2).ShowDetail = False, it would open and close.. however when I try to test if one is True then False Else True it fails? So if my...

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")

Hi All, I have the Cells(Row, Column) value, which I need to use to show the details of this cell value in a specific pivot table. As far as I could see the most common usage is Range and then selection.showdetails = true. I tried using the blow unsuccessfully: Cells(FindRow.Row...

I have a pivot table (working very nicely thankyou!!) which shows the following headings (with an example of data): SITE MANAGER...SAP Code.............................Site Reference.............Site Name [+]Dylan Thorley Clicking the [+] by a Site Manager's name reveals the SAP codes for...

Hi, I have a userform and I would like to update a pivot table based on selected checkboxes. So I have some code which will edit the pivot table: ActiveSheet.PivotTables("Table1").AddFields RowFields:= Array("Name","ID","Age")...