Create Sales Activity

  1. Open a dataset or favorite view.
  2. On the pivot sheet, select the cell or cells that you want to change, right-click and select Calculate Cell(s).  
    The Definition of Sales Activity dialog box is displayed.
  3. On Sales Activity, specify or select a scenario name.
    If you have checked Automatic Default Scenario Per Dataset in General Settings, you are unable to create a new scenario. The Scenario Name field will be deactivated.
  4. In Part Type, specify this information:
    Sales Activity Name
    Specify the name for the sales activity.
    Change Category
    Select a relevant change category.
    To Do List
    Select a to do list if you want to attach the sales activity to a To Do List.
    Sales Activity Description
    Optionally, specify a description for the sales activity.
    Activity State
    Select a relevant value from the drop-down list.
    External Reference
    If available, select an external reference.
  5. Click OK.
    The Basic Calculation or Advanced Calculation dialog box is displayed.
  6. On Basic Calculation or Advanced Calculation, select the Operator, Amount, Column, and Distribution Method.
  7. Click OK.
    The changes is displayed in the pivot sheet. The changed cells are displayed with a colored background and the tool tips provide details about the changes.
    Note: The changes are made at the aggregated level. The changes will be distributed pro rata to the underlying cells. Select whether you want to make basic calculations or advanced calculations prior to creating your sales activity.