hi all. i am new to chandoo's. i am starting to learn as much as possible all the intricacies of excel 2007. especially the advanced features such as filter, tables, pivot tables, macros, and so on.
while studying the pivot table features i came up with a small table of data.
i have by far understood many of the basic features of the pivot table.
however i am stuck on what will surely be something like piece of cake for many of you out there.
hopefully one of you can help me in resolving this issue:
i cant seem to perform a value filter by either row label or column label.
i have made a basic filter such as 'value equal to a piece of data i know actually exists in my pivot table (or source data)' but the pivot returns no results!
here is the rapidshare link to the file.
http://rapidshare.com/files/440052836/difficulty_to_do_a_value_filter_by_row_or_column_label_on_pivottable_excel07.xlsx
it is a small one with one sheet containing the data table and the pivot table.
could anyone please advise what seem to be the problem?
right now im going thru Microsoft's office support but i dont think i will get an answer on my doubt. in fact on one of their tutorials they performed a filter like this one and it worked. so i am wondering if the failure is because of how i designed my source data or the pivot table(?)
i apologize in advance if my issue results to be a dummie solution. im just trying to learn from the best.
thanks anyone for your assistance.
have a good year end and wish you all the best for 2011
best regards,
marianito
while studying the pivot table features i came up with a small table of data.
i have by far understood many of the basic features of the pivot table.
however i am stuck on what will surely be something like piece of cake for many of you out there.
hopefully one of you can help me in resolving this issue:
i cant seem to perform a value filter by either row label or column label.
i have made a basic filter such as 'value equal to a piece of data i know actually exists in my pivot table (or source data)' but the pivot returns no results!
here is the rapidshare link to the file.
http://rapidshare.com/files/440052836/difficulty_to_do_a_value_filter_by_row_or_column_label_on_pivottable_excel07.xlsx
it is a small one with one sheet containing the data table and the pivot table.
could anyone please advise what seem to be the problem?
right now im going thru Microsoft's office support but i dont think i will get an answer on my doubt. in fact on one of their tutorials they performed a filter like this one and it worked. so i am wondering if the failure is because of how i designed my source data or the pivot table(?)
i apologize in advance if my issue results to be a dummie solution. im just trying to learn from the best.
thanks anyone for your assistance.
have a good year end and wish you all the best for 2011
best regards,
marianito