I'm not good in Excel and still learning a lot of things.

I'd like to know if it is possible to filter withing a group in PT.

(-) <Transaction Name>   | <Subtotal>

        <Transaction Time 1> | <Value 1>

        <Transaction Time 2> | <Value 2>

        .........                          

E.g. I have a lot of transactions and each transaction has a lot of transaction timing (i.e. the time when the transaction starts). 

Is it possible to filter within each transaction name group? For example, I don't want all the transaction timing, I only want some timings of each transaction name when the response time is more than 3 secs. Please help me. P.s. I'm using Excel 2007.

• Moved by Fei XueMicrosoft contingent staff Tuesday, July 28, 2015 7:34 AM

Hi Yin,

First of all, I suggest you refer to the article and the video about how to use group feature in Excel.

http://www.gcflearnfree.org/excel2007/10.3
https://www.youtube.com/watch?v=T7JKSKv7b2k

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

If these tutorials are useless for you, I suggest you send a sample file to our email address:
ibsofc@microsoft.com
Please Note: Please add the URL of the case in the email subject or body.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su