If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sales spreadsheet with variable conditions
Wish to create a spreadsheet that will track the potential lost sales of accessories if Widgets sales goal is not met. Example: Goal is 30 % accessories. Sold 100 widgets so potential is 30 Widgets with accessories. Created formulas for units, missed units opportunities, and missed sales opportunities.
Then I used autofilter with drop-down values from 15%-29% (Likely results compared to goal). But when I click on any value other than 15%-everything disappears. Here are my column headings: Total Units Accessories Goal 30% Actual (with drop down autofilter, Missed Units Oppotunities, Missed Sales Opportunities (@$15 per accessory) Thanks |
#2
|
|||
|
|||
Sales spreadsheet with variable conditions
I'm not sure I understand what you're doing.............AutoFilter derives
it's dropdown values (except ALL, TOP TEN, and CUSTOM) from the actual values in each column. If you've got a "29%" value in your "Actual" column, then AutoFilter ought to return that row for you when you click on that value in the dropdown box...........if you're using the CUSTOM window, and seeking a value which does not exist in the column, then everything will disappear because AutoFilter cannot find any row with that value in the specified column...........that's the way it's supposed to work. hth Vaya con Dios, Chuck, CABGx3 "C'est Possible" wrote in message news Wish to create a spreadsheet that will track the potential lost sales of accessories if Widgets sales goal is not met. Example: Goal is 30 % accessories. Sold 100 widgets so potential is 30 Widgets with accessories. Created formulas for units, missed units opportunities, and missed sales opportunities. Then I used autofilter with drop-down values from 15%-29% (Likely results compared to goal). But when I click on any value other than 15%-everything disappears. Here are my column headings: Total Units Accessories Goal 30% Actual (with drop down autofilter, Missed Units Oppotunities, Missed Sales Opportunities (@$15 per accessory) Thanks |
Thread Tools | |
Display Modes | |
|
|