The Excel addin Fieldpine GlobalData allows you to insert formulas into an Excel spreadsheet and retrieve information directly from your retail system. With this you can create highly specific custom reports that dynamically recalculate each time you open them.
Returns a single value from a selected chip
Syntax =Chip(Chip-Name, Display-Field, Result-Index, Optional Parameters)
Selects which "chip" (bit that actually understands what you are asking for) to select, such as products, customers, sales, weather.
Specifies the value you want to see displayed. The possible keywords that can be used here depends on the chip selected
If the selection processing from this chip results in multiple possible values, this parameter can be used to select which result you want. All the values are selected and placed in a sorted array. If you want the top most value, pass "1" in this parameter, 2 for the second item, and so on.
If you do not specify a result index, or specify zero as the result index, then the first/only item is displayed, unless there are more than one result values present, in which case an error is returned to Excel. Essentially a value of zero says I'm only expecting one value so return an error if there are multiple results present.
A series of selection criteria. See @@. These parameters may be simple values, references to other cells, or even an array values.
Returns array of values from a selected chip. The output of this function MUST point to an array of cells to store results.
Syntax =Chip(Chip-Name, Display-Field, Optional Parameters)
This function works the same as Chip() routine, except this function is internally marked to let Excel know it can save the output result when needed again, rather than recalculating. This can increase calculation performance, but also may mean that Excel does not reflect changes instantly. You may need to periodically press ctrl-alt-F9 to force a complete recalculation of all formules.