Hi there
I have a list of products that I monitor their sales figures every week. However, I would like to zoom in on those products that are the performing badly.
How can I easily filter out the products IF the latest group of dates is NEGATIVE as shown in the picture?
Thank you
There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You are correct. HEre is a excel spreadsheet that I would like to filter for those values in YELLOW as they are negative percentages.
Just to clarify, after filtering, I need to see Product C not shown in the pivot table.
Which version of Excel? 9 means nothing to me ...
Is this anything like what you want?
AliGW on MS365 Beta Channel (Windows 11) 64 bit
Name C Row Labels Sum of Quantity Sum of Quantity2 10/10/2022 - 12/10/2022 16/10/2022 - 18/10/2022 19/10/2022 - 21/10/2022 07/10/2022 - 09/10/2022 Grand Total
Sheet: Sheet1
HIhi using 2021 version.
I wanted to show only Name A and C as the last dates on it are NEGATIVE. LEt me see if I can show it in the excel
This should be what is remaining - I have hidden some dates as it was too long to put it in 1 screenshot
THe reason why Product A and Product B are still in the pivot is because of the latest date percentage which is NEGATIVE
Product A 25/10/2022 - 26/10/2022 6 -53.85%
Proudct B 25/10/2022 - 26/10/2022 60 -94.23%
while Product C is remove as the latest date is POSITIVE
Product C 19/10/2022 - 21/10/2022 53 488.89%
Please update your forum profile NOW.Ihi using 2021 version.
Sorry, I am not following your explanation. I shall leave this to someone who is.
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
FWIW, my understanding is that a filter should be applied to the Pivot Table to REMOVE in their entirety any/all products where the most recentl weekly total is a positive number.
Irrrespective of undisclosed cross-posting issues, I'm not doing anything more here, as I doubt if this can be done in a Pivot Table. Certainly, i haven't a clue where to start.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks