Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Pivot Table question

Posted on 2013-11-11
2
Medium Priority
?
191 Views
Last Modified: 2013-11-13
Hi Guys, I am trying to Rec duplicate trades so I have done a Pivot and Count on Trade Id, but how do I filter the Pivot Count so that it shows more than "1", eg. 2 and over?


I enclose my Pivot table
0
Comment
Question by:Justincut
2 Comments
 

Author Comment

by:Justincut
ID: 39639051
0
 
LVL 37

Accepted Solution

by:
Kimputer earned 2000 total points
ID: 39639099
You're talking about the Value column, so the closest thing to what you want is to sort it either Largest to Smallest (or vice versa).

You can also add a filter, but you will lose oversight. As in, click the filter icon in the Row labels, Add value filter, for this example choose Greather than, since this is a simple table, the settings are mostly correct, just fill in 1.
Now your table only shows for the value table Count of GBO_ID of 2 and higher.

I know you want it to react the same as the other filter icon, but this is what you will have to work with.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question