No announcements
Found 2870550 threads
-
0 VotesSet a pivot table filter value from a cell
set that filter date to the value in a cell. I keep getting an error: Dim PvtTbl AsAnswered | 1 Replies | 613 Views | Created by Geek 2016 - Tuesday, August 11, 2015 3:45 AM | Last reply by Hans Vogelaar MVP - Tuesday, August 11, 2015 5:42 AM
-
0 Votes
Implicit Aggregate in pivot table ?
would like to remove the months and only keep the Grand Total. But you cannot move a set to the page filter area, so I tried the following workaround with the add-in ...Answered | 1 Replies | 975 Views | Created by Bertrand d'Arbonneau - Thursday, March 20, 2014 9:26 AM | Last reply by Bertrand d'Arbonneau - Thursday, March 20, 2014 2:26 PM -
0 Votes
Entering filter value in pivot table manually/by reference to another cell
an excel pivot table : I have multiple pivot table connecting to an external data source (OLAP cube), and I would need to set the ...Answered | 4 Replies | 7616 Views | Created by Thibaut Morpheo - Wednesday, July 15, 2009 4:35 AM | Last reply by Avinash R - Monday, July 27, 2009 10:20 PM -
0 Votes
Get the value for a filter of a pivot table
Hi, in an Excel workbook I need to get the value of a pivot table filter by VBA. Is it possible? And how can I ...Answered | 6 Replies | 14408 Views | Created by pscorca - Thursday, May 26, 2011 1:43 PM | Last reply by cbutcheratum - Thursday, January 9, 2014 9:45 PM -
0 Votes
Updating Pivot filter based on cell value
Thanks Terry, that worked. The pivot refreshes to change the filter but it is selecting multiple items instead of the entered value. Any thoughts?Answered | 2 Replies | 277 Views | Created by wandering_angel - Wednesday, August 30, 2017 7:29 PM | Last reply by wandering_angel - Thursday, August 31, 2017 10:45 AM -
2 Votes
how to refer a pivot table filter to a cell and update it automatically?
A1 hasn't changed. Something like having a dummy cell (say B1) to hold the previous value of A1 (which is set at the end of the macro code), and at the start of ...Answered | 13 Replies | 38933 Views | Created by kapiszon2929 - Sunday, May 4, 2008 7:41 PM | Last reply by kkleimola - Friday, April 3, 2009 2:34 PM -
0 Votes
XL 2010 - Filter a pivot table field based on another cell value
How do I set the CurrentPage to an address, not a text value. I want the Pivot Table to dynamically display when another cell ...Answered | 2 Replies | 4596 Views | Created by Syswizard - Tuesday, February 28, 2012 2:28 PM | Last reply by Syswizard - Tuesday, February 28, 2012 6:12 PM -
0 Votes
Pivot Table VBA Filter
Thanks for the reply Fei, Just to clear things up I want to set my pivot filter to a field called "Pivot Table" and ...Answered | 3 Replies | 1636 Views | Created by Blue_Dan - Thursday, February 5, 2015 4:33 PM | Last reply by Fei Xue - Monday, February 9, 2015 6:34 AM -
1 Votes
Pivot Table Multi Select Filter Value Performance
. One is like yours to loop the rows one by one. In another way, I suggest you copy the entire Pivot table to the left area, and then filter the new table with ...Answered | 5 Replies | 997 Views | Created by AuroraMan1 - Thursday, November 5, 2015 7:12 PM | Last reply by Edward8520 - Friday, March 18, 2016 8:25 AM -
1 Votes
automate filter functionality in a pivot table
I have a pivot table. It is based on a data table located on another worksheet. I am trying to set up a filter on the ...Answered | 6 Replies | 9821 Views | Created by ChitownDotNet - Sunday, November 28, 2010 7:16 AM | Last reply by Vasudevan - Wednesday, June 27, 2018 11:24 AM -
0 Votes
SetCellA1 does not work for Pivot Table filters
I expose a Sheet1 in Excel Services which has a Pivot Table with 3 filter fields (named as parameters) as well as a separate single cell ...Answered | 4 Replies | 11110 Views | Created by MichaelL - Wednesday, May 30, 2007 10:08 PM | Last reply by Mike Walsh FIN - Thursday, July 16, 2009 12:19 PM -
1 Votes
Pivot Table Filter values
When I establish a pivot table, and then the data source has it's values change, the filter values do not change. Even a REFRESH of the pivot ...Answered | 3 Replies | 1710 Views | Created by Syswizard - Friday, August 24, 2012 3:57 PM | Last reply by Hans Vogelaar MVP - Friday, August 24, 2012 5:26 PM -
0 Votes
How to Filter pivot table based on cell values
Hi there! I need to filter a date field in pivot table in a dynamic way. From what I've searched, since I'm using an OLAP ...Answered | 3 Replies | 1480 Views | Created by Nunoadlima - Saturday, October 15, 2016 5:41 PM | Last reply by Asadulla Javed - Monday, October 17, 2016 6:16 PM -
0 Votes
Pivot table filter sorting
Okay... I moved it to the Rows section, selected the field in the actual pivot table, clicked sort ascending button in the Ribbon, then moved it back to ...Answered | 7 Replies | 5002 Views | Created by adamhodge - Thursday, May 26, 2011 1:49 AM | Last reply by mjlenox - Thursday, March 12, 2015 4:26 PM -
0 Votes
pivot table filter
Hi, I have an excel workbook published to EWA displaying a pivot table and chart (in MOSS 2007). In the workbook version I ...Answered | 4 Replies | 9396 Views | Created by phbern - Thursday, April 1, 2010 2:32 PM | Last reply by David M - MSFT - Saturday, April 3, 2010 7:56 AM -
1 Votes
SSAS Dynamic set from Excel pivot table
Pivot table, the bottommost entry is from this tool. Tt has an MDX tab that shows you the MDX that Excel generates. Maybe someone in thsi forum could help you better when ...Answered | 2 Replies | 4876 Views | Created by Javier Guillen - Friday, October 23, 2009 8:48 PM | Last reply by Javier Guillen - Monday, October 26, 2009 1:42 PM -
0 Votes
Multiple Pivot Table Filter Update
that there is a AfterUpdate trigger, does excel have this to? I want to run the macro after the filter selection has been made in the pivot table. Thanks MASAnswered | 1 Replies | 5006 Views | Created by MikeSierra - Friday, November 20, 2009 7:22 PM | Last reply by Dileep.Y - Tuesday, November 24, 2009 6:22 AM -
0 Votes
Retrieving a value from a gridView cell
get value inside the cell like this : object obj = datagridView.Rows[e.RowIndex].Cells[ e.ColumnIndex].Value; Wife is like ...Answered | 1 Replies | 3659 Views | Created by A n t - Friday, July 4, 2008 8:01 AM | Last reply by jack_2009 - Friday, July 4, 2008 9:34 AM -
0 Votes
Excel VBA Pivot Table Filter
Hi All I have a large worksheet and use a pivot table to extract data on a property ID basis. At present, I select each ...Answered | 1 Replies | 915 Views | Created by Keith D P - Friday, September 26, 2014 8:48 PM | Last reply by danishani - Friday, September 26, 2014 10:40 PM -
1 Votes
How to set a table cell margin
Cell tab -> Options... which brings up the cell margins form where I can set the margins properties) in Word.Answered | 7 Replies | 18850 Views | Created by feg2008 - Wednesday, June 1, 2011 2:44 PM | Last reply by feg2008 - Monday, June 6, 2011 3:57 PM - Items 1 to 20 of 2870550 Next ›
No announcements
