Show TOC

Average Deal Size Locate this document in the navigation structure

Query Query: 0CSALMP05_Q3000

 

This query provides you with an overview of the average deal size and of the revenue attained in each of the previous 8 quarters including the current quarter.

This query is based on the MultiProvider 0CSALMP05.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

User Name

0BP_RESPPER__0USER_NAME

User Name: 0P_USER

Characteristic Characteristic

System of User Name

0BP_RESPPER__0USER_SYST

System of User Name: 0P_USSYS

Characteristic Characteristic

Resp. Sales Org.

0CRMSA_OG_R

Determine Manager's Sales Organization: 0CXPMOM
Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

Industry Code

0CRM_PROSPE__0IND_CODE

Characteristic Characteristic

CRM Sales Org.

0CRM_SALORG

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

No. of Document Headers

0CRM_NUMDOC

—

Key Figure Key Figure

Order: Net Value

0NETVALORD

—

Key Figure Key Figure

Average Deal Size

Net order value / number of document headers
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Variable Variable

Quarter 8 (Previous)

&0T_CQUARTER&

Current quarter minus 7 quarters

Variable Variable

Quarter 7 (Previous)

&0T_CQUARTER&

Current quarter minus 6 quarters

Variable Variable

Quarter 6 (Previous)

&0T_CQUARTER&

Current quarter minus 5 quarters

Variable Variable

Quarter 5 (Previous)

&0T_CQUARTER&

Current quarter minus 4 quarters

Variable Variable

Quarter 4 (Previous)

&0T_CQUARTER&

Current quarter minus 3 quarters

Variable Variable

Quarter 3 (Previous)

&0T_CQUARTER&

Current quarter minus 2 quarters

Variable Variable

Quarter 2 (Previous)

&0T_CQUARTER&

Current quarter minus 1 quarter

Variable Variable

Current Quarter

&0T_CQUARTER&

—