i would create a list box
with only the top 12 items
by using something like:
if (rReturnLagOffset = '6', rSaleAmountLag6
,if (rReturnLagOffset = '5', rSaleAmountLag5
,if (rReturnLagOffset = '4', rSaleAmountLag4
,if (rReturnLagOffset = '3', rSaleAmountLag3
,if (rReturnLagOffset = '2', rSaleAmountLag2
,if (rReturnLagOffset = '1', rSaleAmountLag1
,if (rReturnLagOffset = '0', rSaleAmountLag0
then via macro select possible in the listbox
if you can post sample data
we can work it together
I have several line charts on a tab, one for return rates (returns divided by sales as percentages) by item, one for return rates by customer, and 3 straight tables that provide tabular totals for sales and returns. By default we want to see this data for the last 12 months for the top 12 products. I created the ltmSelector function for the last 12 months easily which I can fire via a button or on document load. I'm having difficulty with the top 12 items though. These same charts need to honor all selections so that they can change the date range and items/categories/etc. This is just a common view they want to default to or be able to quickly return to.
That's a good idea and one I hadn't considered, but can I have multiple list boxes for the same field? Currently, I'm getting possible values with ActiveDocument.Fields("rMasterItemNo").GetPossibleValues. How would it know, or how would I tell it to use the top 12 list box versus the list box containing all items? Perhaps when you say Macro you're referring to something other than VB Script? I'll need to look into that...