Page Comparison

Use advanced search to locate product sales that are ahead of target

...

1. Choose the 'Sales' database and select the Search icon Image Modified .

2. Choose 'Product' from the dimension drop down box.

3. Select Plus   > Calculation.

4. Define the variables as the nine days in December when the promotions were active:
   • Select the gray Plus Image Modified to add variable a. Choose Stream = Sales and Measure = Value, and then click the period tab, set the Time Unit to Day, and start on 2^nd Dec and end 4^th Dec.
   • Add variable b. Choose Stream = Sales and Measure = Value, and then click the period tab, set the Time Unit to Day, and in our case start on 12^th Dec and end 13^th Dec.
   • Add variable c. Choose Stream = Sales and Measure = Value, and then click the period tab, set the Time Unit to Day, and in our case start on 23^rd Dec and end 26^th Dec.
   • To add up the sales on all the promotional days, in the Expression box, enter the formula 'a+b+c'
   • From the Search Type drop down, choose Greater Than and enter '10000'.
   • Your set of rules should appear similar to the image below. Apply.
     
     Image Modified

A list of products that have exceeded sales of $10,000 on promotional days will appear and a summary of your advanced search rules will appear in the Status bar.

...