Item to Report Group Percentage Report

Purpose

The Sample Item to Report Group Percentage Report, shown below, is designed to calculate the percentage of Total Chicken Sales that 2pc Combos make up and the Variance between the store’s Percentage of Chicken Sales and the corporate average.

Figure 3.4.13 Sample Item to Report Group Percentage Report

Focus POS Corp

2PC Combo Units for 3/1/200x-3/31/200x at 10/24/200x 1:16:51 AM Page 1

======================================================================

Downtown | 1082 | 13071 | 8.28 | -0.25 |

Spring | 1333 | 13801 | 9.66 | 1.13 |

Tomball | 903 | 12188 | 7.41 | -1.12 |

Westheimer | 1159 | 13238 | 8.76 | 0.23 |

----------------------------------------------------------------------

Totals | 1119.25 | 13074.50 | 8.53 | |

======================================================================

Figure 3.4.14 Sample Item to Report Group Percentage Report Fields

Field

Description

Store ID

Column 1

Displays the Restaurant ID established in Setup > Restaurants > ID.

# of 2pc Combos

Column 2

Displays the number of 2pc Combos sold during the selected date range. Note: This column uses a List.

Total Chicken Units

Column 3

Displays the number of units for the Chicken Report Group.

Percentage of Chicken

Column 4

Displays the percentage of 2pc Combos to Total Chicken Units.

Variance

Column 5

Compares the Percentage of Chicken against the corporate average.

Totals

# of 2pc Combos	Column 3 Displays the total number of units sold for the 2pc Combo for all stores.
Total Chicken Units	Column 4 Displays the total number of units sold for the Chicken Report Group for all stores.
Percentage of Chicken	Column 5 Displays the corporate average of 2pc Combo Units to Total Chicken Units.

Report Setup - Column 1 (Store ID)

Field	Setup Information
Heading 1	Store ID
Heading 2
Size	10
Sort	Ascending
Format	Text
Display	Yes
Filtered	No
Expression	“REST-NAME”
Constant	n/a

Report Setup - Column 2 (2pc Combos)

Field

Setup Information

Heading 1

# of

Heading 2

2pc Combos

Size

Sort

<None>

Format

Integer (Avg. Total)

Display

Yes

Filtered

Yes

Filter Options

Field	Option
List	2pc Combo

2Pc Combo List Options

Type

Menu Items

Item

2pc Combo

Note: “2pc Combo” is the ID of the Menu Item for the List.

Expression

“RGUnits1:CHICKEN”

Note: CHICKEN is the name of the Report Group.

Constant

n/a

Report Setup - Column 3 (Total Chicken Units)

Field	Setup Information
Heading 1	Total Chicken
Heading 2	Units
Size	15
Sort	<None>
Format	Integer (Avg. Total)
Display	Yes
Filtered	No
Expression	“RGUnits1:CHICKEN” Note: CHICKEN is the name of the Report Group.
Constant	n/a

Report Setup - Column 4 (Percentage of Chicken)

Field	Setup Information
Heading 1	Percentage
Heading 2	of Chicken
Size	10
Sort	<None>
Format	Currency (Avg. Total)
Display	Yes
Filtered	No
Expression	“Column2” / “Column3” * 100.00
Constant	100.00

Report Setup - Column 5 (Variance)

Field

Setup Information

Heading 1

Variance

Heading 2

Size

Sort

<None>

Format

Currency (Avg. Total)

Display

Yes

Filtered

Yes

Filter Options

Field	Option
Totals Stop Column	2

Expression

“Column4” – “ColumnTotal4”

Constant

n/a

Report Format Options

Field	Option
File Format	Text
Totals by Date	Not Selected
Type	None

Related Topics (none)