Region | America | Europe | Overall Result | ||||||
---|---|---|---|---|---|---|---|---|---|
Customer | FC016 Plaza Mayor | Result | FC001 Anchor Inn | Result | |||||
Calendar Year | 2004 | Result | 2003 | 2007 | Result | ||||
Net Sales Europe | Anchor Inn | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 2.00 | EUR 5.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 |
Anchor Inn with CSC | EUR 2.00 | EUR 5.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | ||||
Anchor Inn with CSE | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | ||||
All Customers (Anchor Inn, Plaza, Bennati) | EUR 2.00 | EUR 5.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | ||||
Net Sales Europe with CSC | Anchor Inn | EUR 7.00 | EUR 7.00 | EUR 2.00 | EUR 5.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | |
Anchor Inn with CSC | EUR 7.00 | EUR 7.00 | EUR 2.00 | EUR 5.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | ||
Anchor Inn with CSE | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | ||
All Customers (Anchor Inn, Plaza, Bennati) | EUR 7.00 | EUR 2.00 | EUR 5.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | |||
Net Sales Europe with CSE | Anchor Inn | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 |
Anchor Inn with CSC | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | |
Anchor Inn with CSE | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | |
All Customers (Anchor Inn, Plaza, Bennati) | EUR 12.00 | EUR 12.00 | EUR 12.00 | EUR 12.00 | EUR 12.00 | EUR 12.00 | EUR 12.00 | EUR 12.00 | |
Net Sales | Anchor Inn | EUR 2.00 | EUR 5.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | |||
Anchor Inn with CSC | EUR 2.00 | EUR 5.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | ||||
Anchor Inn with CSE | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | EUR 7.00 | |
All Customers (Anchor Inn, Plaza, Bennati) | EUR 3.00 | EUR 3.00 | EUR 3.00 | EUR 2.00 | EUR 5.00 | EUR 12.00 | EUR 12.00 | EUR 12.00 |
In the global filter, the query only contains the customers Anchor Inn and Plaza Mayor.
The outer structure contains key figures with filters on the region; either without constant selection (Net Sales Europe, Net Sales), with constant selection on characteristic Region (Net Sales Europe with CSC), or with constant selection on the structure element (Net Sales Europe with CSE).
The inner structure contains filters on the customer, either without constant selection (Anchor Inn, All Customers), with constant selection on characteristic Customer (Anchor Inn with CSC) or with constant selection on the structure element (Anchor Inn with CSE).
All cells in which either the structure element of the outer structure or of the inner structure has the property Constant Selection on the structure element (CSE), are completely constant and are thus completely independent of the drilldown. For structure element 'All Customers' in combination with CSE, the data for customer Banquetes Bennati Ltd also appears in the total.
All cells that have only activated constant selection on the characteristic (CSC) either on the region or the customer or on both, are not constant in terms calendar year, meaning that there are detailed values for the calendar year.