Use Two Filters Within A The Same Field?

Jul 18, 2014

is it possible to use two filters within a the same field.

ie. right now i can filter using the top 10 based on a value field.

what if i want to see the top 10 customers profit and along any drop in revenue from previous years..

something like this.

the information below was copied out of a pivot table that included the % difference.

Code and Name
YearCheck
Profit
Difference

[Code].....

View 1 Replies


ADVERTISEMENT

Apply Two Filters To Field In Pivot Table Via VBA

Jun 2, 2014

I'm trying to apply two filters to a Pivot Table field via VBA, but the syntax is beating me.

If I want to add both a xlTopCount and a xlValueIsGreaterThan, how do I do it? I need this because I want my Top n values to not include 0 values.

View 4 Replies View Related

Advanced Filters - Having Multiple Filters And Conditions (Unique Count)

Jun 7, 2006

I have a problem with the attached spreadsheet. I have certain letters (A,B,C etc.) that are shipped to various regions. I would like to have a count on top to count the total number of orders, but one that also counts the total number of unique orders. However, this unique count has to be dynamic and must be able to adjust accordingly to the filters (by default, if no other filters are applied, should be 15). For example, if I apply the "Ship To" filter to Canada, the total number should be 19, but the unique count should be 12. If I change the "Ship To" filter to US, the total number should be 9, and the unique count should be 7. I've tried to use the advanced filters but if I apply the unique entries filter, it is only a one time calculation. Also, the advanced filter gets rid of my other filters.

View 5 Replies View Related

Pivot Filters To Change Simultaneously With Other Pivot Filters?

Jul 1, 2014

I have 3 pivot tables and with 3 filters each (they are all the same filters). I just want to change 1 of the filters for each of the pivot table (meaning the other 2 stay the same for all of the pivots). Is it possible to have a filter change automatically to match a filter in another pivot?

View 9 Replies View Related

Auto Populate Field With Date When Other Field Is Selected From Validation List

Jul 4, 2013

In the following extract, I would like to have today's date placed into Col K when an entry is made into Col J.

Entry into Col J is from a validation list of 3 options. What I desire is that when one of these options is selected ("Complete"), then I would like today's date to be written into Col K.

Currently Col K has a validation list which comprises dates from 1st of each month from July to June.

I need a fixed date as text preferably, so was thinking the VBA function "Date" on a Change Workbook Sub.

The information is currently part of a Table in Excel 2007 that has about 500 records.

IdeasList

*
J
K

2
Status
Month Completed

3
In Progress
*

4
Complete
Jul-13

5
*
*

6
*
*

Data Validation in Spreadsheet

Cell
Allow
Datas
Input 1
Input 2

J4
List
*
=ValidationList_Status
*

K4
List
*
=ValidationList_Months
*

View 2 Replies View Related

Macro To Preset Field With Text If Condition In Another Field Is True

Jun 9, 2006

I have a macro that imports a report. If the Charge Type in column A is BTOREPLX, I need to prefill the field next to it in column B with the text "REPLX", e.g. "REPLXCDROM". I've attached an example of the report.

View 5 Replies View Related

Change/Move Pivot Table Row Field To Column Field

Apr 23, 2008

In building my pivot table my data that I want to show in the column area is showing up as rows stacked on top of each other. In the column section I'm trying to show Total Budgeted Amount next to Total Actual Amount but on the layout it's showing the two stacked on top of each other is there some kind of hidden key that I'm missing?

View 3 Replies View Related

Getting Zero Formula Field When Data Field Blank / Empty

Feb 13, 2013

I have a simple formula ='info page'!b2&'info page'!b5 in places that on my sheet adds a company prefix to a item number, prefix in b2 and item in b5, we have a client that we cant use prefixes but now when I leave the field blank its giving a zero and thats not good either. I'm pretty sure an IFERROR or something will work but can get the syntax right.

View 5 Replies View Related

Auto Populate A Field In One Tab By Comparing Another Field In A Different Tab?

Jan 25, 2013

I have a tab called 'Tab1' in which I have column called 'Col1' and 'Col2'.

I have another tab called 'Tab 2' with columns 'ColA' and 'ColB'. When I enter a text in Col1(Tab1) I would like that text to be compared to data in 'ColA' from Tab 2 and when match found then get the corresponding value from ColB and autopopulate it in Col2 of Tab1.

View 2 Replies View Related

Changing A Numerical Field To A Date Field

Dec 28, 2006

in coverting these fields into a date field.

Example 91306 to 060913

I have encloed the file.

View 14 Replies View Related

Counting Per Date Field And Data Field

Apr 29, 2006

I am trying to count the number of times that data is in a field and in any field the date is greaert than today's date. This date field could be blank and that is where I am having the problem.

Example

See Attached

View 4 Replies View Related

Concatenate Two Text Fields BUT Left Adjust First Field And Right Adjust Second Field

Jun 22, 2012

I want to concatenate two Cells into a single cell BUT have the first field left justified and the second cell right adjusted.

A1 = "John Williams", A2= "Single"

A3 = "John Williams Single"

View 1 Replies View Related

Unable To Use Filters

Jul 10, 2007

I have a worksheet that is unprotected but I am unable to apply filters to it. The option is greyed out if I try and select autofilters.

Another strange thing is that on one of the worksheets when I select Data, Filters there is a tick to the left of Autofilter but it is also greyed out, so in effect I cannot turn it off even tho I can't see the filters!

I have tried to popst a screen shot but unsure how to do it. I think maybe a screen shot would help to explain my issue better so if anyone knows how to do this......

View 9 Replies View Related

Filters The VLOOKUP In Vba

Jan 2, 2008

Let's say that A1:C5 looks like this:

Square Red $5
A2 is empty Blue $6
A3 is empty Orange $2
Circle Puple $10
A5 is empty Black $18

A2 and A3 could say "Square" and A5 could say "Circle" ... this is just how I have it set up right now.

In C1 I have a drop down list ... a list of "Square" and "Cirlce".

***QUESTION***

Is there a way for a user to select "square" from the drop down list and in D1 have excel populate a list of all the Squares colors and prices?

Example of what excel would populate in D1:E3:
Red $5
Blue $6
Orange $2

The thing is that I don't think filters is the answer. The reason being is that I want the user to be able to select the item from the list and have excel automatically populate the information. The user should not have to filter the list manually.

View 9 Replies View Related

Filters With OR Function

Aug 11, 2008

In my Sheet I have AutoFilter on multiple columns.
I want to view all rows where in different colomns there are values.

For example
Colomn D, Row 6 has a value
Colomn E, Row 6 has no value, But Colomn E, Row 7 has a value.

I want to view then Row 6 and 7, by setting an OR filter 9 or something like that .

by setting filter on Colomn D with ( not empty Cell ) and Filter on Colomn E with (not empty Cell ) it is only a AND function.

How can I get an OR function. ( Colomn D OR Colomn E )?

View 9 Replies View Related

Filters And Criterias

Feb 20, 2009

I'm trying to modify this code in order to do the following.

I want to choose first column and then the criteria for filter, then i want to choose a second column and criteria to filter the remain values from the first filter.

Here is my
Sub Filter()
Dim Myrange As Range
Dim CriteriaVal As Variant
Dim CriteriaVal2 As Variant

Dim KillColumn As Integer
Dim KillColumn2 As Integer
Dim ActiveColumn As String
Dim AC
Dim LastRow As Long
Dim rng As Range

View 9 Replies View Related

Using Pagefields Like Filters

Jul 26, 2006

I have several pagefields. Once something particular has been selected in one of them, I would like the remaining options in the other pagefields to be updated or refreshed showing only those where there is a correlation with the selected pagefield. In other words, exactly how your typical Excel filter works.

I assume there is no option to change the way pagefields interact to be like filters. How could this be done in VBA?

View 7 Replies View Related

Drop Downs & Filters

Dec 16, 2008

First post so please excuse me if this has been covered before but I am trying to get the results of a dropdown menu in one worksheet to become the criteria for a filter in another worksheet (both in teh same workbook).

I thought I could just add a reference to the dropdown cell into the autofilter (in VBA editor) but it doe't seem to be that simple.

Any ideas?

View 10 Replies View Related

Macro For Filters With Exceptions?

Jan 20, 2010

I am using Excel 2007. I have a list of 100 names all ranked from 1-100. Is there a way to create a macro that can filter out the top 20, a specific name and also any names with the cell colours blue and yellow?

At the moment using an advanced filter based on criteria I can filter out the top 20 and the specific name I want but can't work out how to leave the coloured rows in as well.

View 3 Replies View Related

Subtotals In Groups Vs Filters

Dec 12, 2008

Subtotal doesn't add cells hidden under a filter column but it does when grouping. How can I get groups to change a subtotal based on whether they are hidden or not. What I'm really trying to do is use conditional formatting to change the format when a group is expanded vs collapsed.

View 3 Replies View Related

Summary Fields With Filters?

Feb 11, 2010

I'm creating a spreadsheet with data I've exported from a survey.

My data begins column headings on row 10 and spans across several columns. I've applied filters to the headings.

Above column 10 I have some summary data using the countif and counta functions. Is there away to have my summary fields change as I apply my filters to the main body of data in different ways?

View 11 Replies View Related

Mutiple Filters Using VBA Or Non VBA Method?

May 8, 2012

I need to apply filters based on 2 criteria

Filter1Dropdown SelectionFilter2Dropdown SelectionHeader1Header2Header3Header4Header5Header6

Depending on what is selected in Filter 1, lets say it applies to column F and i get a data set

Now with the filtered dataset of Filter 1, I should be able to apply Filter 2 or vice versa.

Also at the end, I need to release all filters so that i can see the entire data set.

View 2 Replies View Related

Creating Independent Filters?

Aug 1, 2012

Is it possible to create independent filters. I have data for five departments and sales for different quarters of the years. These sales for the different quarters are independent. But If I select Q1 for first department and Q2 for second department it do not give me the result that I seek i.e. sales for first department for Q1 and Sales for second department for Q2.

View 9 Replies View Related

Filters Across Multiple Sheets

Jan 19, 2007

Are there any events associated with filters?

If I have two sheets of data, where column A is NAME and column B is GRADE. Sheet1 is MATH and Sheet2 is ENGLISH. The same students are taking both classes.

Is there a way to make it so that when I filter by GRADE in tab 1, tab 2 is ALSO filtered by the same selection?

View 9 Replies View Related

Multiple Auto Filters

Sep 25, 2009

I am trying to get a simple auto filter on 3 tables in the same spreadsheet.

I have seen this in other documents but have never been able to figure out how to do it.

Cells that need the auto filter are

C8 (Range C9 to C24)

C29 (Range C30 to C45)

C50 (Range C51 to C66)

View 9 Replies View Related

Sum Revenue After 3 Filters And 1 Criteria

Aug 6, 2006

I made 2 sheets: the first one contains the database and in the second one i want to analyze it. Now i am looking for a special sum- function. I want to sum total revenue for a particular company (criteria 1), in a filtered country (criteria 2), month (criteria 3) and class (criteria 4). I'd like to first execute the three filters (country, month and class) and then be able to total revenue of that particular company. Note that after the filters still several companies are visible in the database. Does anyone know how to calcalate this in cell B9:B12 (Analyze sheet) of my attached file.

View 9 Replies View Related

Subtract Data Pivot From Different Filters

Apr 4, 2014

I have a question, I have a pivottable with data (only numbers as values). In this pivot there is a report filter which filters current month and last month. Is it possible for the pivot to show the data as a difference between current month and this month and if so where to start with the vba code to let it substract from each other?

View 6 Replies View Related

Pivot Table Filters With OR Operator?

Nov 26, 2013

filter a pivot table that contains these 3 column fields: User 1, User 2, and User 3.

However, when I want to see the results for "John" in all those fields, I need to use one filter at a time. Is there any other way to see all results of the Pivot Table where "John" is a User, no matter if he is the 1, 2 or 3 user?

View 3 Replies View Related

How To Combine Two Filters Into One In Pivot Table

Dec 2, 2013

I have A3 and A4 as report filters in the pivot table. Is there any way can combine A3 and A4 into one cell. The new cell is something like drop-down list contains contents from A3 and A4. When picking up the from this drop-down, the corresponding data list will be shown (like the data in B3 and B4).

PivotTable_Filter_01.jpg
PivotTable_Filter_02.jpg

View 3 Replies View Related

Excel 2010 :: DAX Calculate With Two Filters

Dec 24, 2013

Using Excel 2010

How can I use 2 filters in DAX Calculate?

I tried

MyCalc:=CALCULATE([MyMeasure], Filter(Tbl,Tbl[Field] && Tbl2,Tbl2[Field2])) It works with 1 Filter : MyCalc:=CALCULATE([MyMeasure], Filter(Tbl,Tbl[Field])) Just falls down when I add the second filter.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved