bpc 12-01-16.docx
TRANSCRIPT
-
7/25/2019 BPC 12-01-16.docx
1/28
on_1_1
Note: The format settings in lower sectio
!olumn
3
"ow
3
Priority to Column Format
Apply
Apply
Apply
Apply
Apply
Apply
-
7/25/2019 BPC 12-01-16.docx
2/28
"ow
!olumn
"ow
Priority to Column Format
Apply
Apply
Apply
Apply
Apply
Apply
Apply
Apply
Apply
Apply
Apply
Apply
Priority to Column Format
Apply
Apply
-
7/25/2019 BPC 12-01-16.docx
3/28
!olumn Apply
Apply
Apply
Apply
-
7/25/2019 BPC 12-01-16.docx
4/28
EPM Fo
s overrides the ones in upper section if there are conflicts.
Hierarch
#efault Format
&ase evel Format
Formatting on Specific evel:
Level 1
Level 2
Level 3
#efault Format
&ase evel Format
Formatting on Specific evel:
Level 1
Level 2
Level 3
Priority to Row Format Relative LevelsStructure Levels
-
7/25/2019 BPC 12-01-16.docx
5/28
#imension Me
!ustom Mem$er #efault Format
!alculated Mem$er #efault Format
)nputa$le Mem$er #efault Format
ocal Mem$er #efault Format
!hanged Mem$er #efault Format
Formatting on Specific Mem$er%Property:
!ustom Mem$er #efault Format
!alculated Mem$er #efault Format
)nputa$le Mem$er #efault Format
ocal Mem$er #efault Format
!hanged Mem$er #efault Format
Formatting on Specific Mem$er%Property:
"ow and
*dd Formatting
Even Formatting
Priority to Row Format
Priority to Row Format
-
7/25/2019 BPC 12-01-16.docx
6/28
*dd Formatting
Even Formatting
Page
#efault Format
Formatting on Specific #imension:
-
7/25/2019 BPC 12-01-16.docx
7/28
matting Sheet
evel Formatting
#ata +se Header
10000 All Label
10000 All Label
10000 All Label
10000 All Label
10000 All Label
#ata +se Header
10,000 All Label
10,000 All Label
10,000 All Label
10,000 All Label
10000 All Label
Start formatting from the lowest level displayed
Appl
Appl
-
7/25/2019 BPC 12-01-16.docx
8/28
$er%Property Formatting
#ata +se Header
10000 All Label
10000 All Label
10000 All Label
10000 All Label
10000 All Label
#ata +se Header
10000 All Label
10000 All Label
10000 All Label
10000 All Label
10000 All Label
!olumn &anding
#ata +se Header
10000 All Label
10000 All Label
-
7/25/2019 BPC 12-01-16.docx
9/28
#ata +se Header
10000 All Label
10000 All Label
(is Formatting
Header +se
Label All
-
7/25/2019 BPC 12-01-16.docx
10/28
+se
All
All
All
All
All
+se
All
All
All
All
All
Format to:
Outer Dimension
nner Dimension
Format to:
Outer Dimension
nner Dimension
-
7/25/2019 BPC 12-01-16.docx
11/28
+se
All
All
All
All
All
+se
All
All
All
All
All
+se
All
All
-
7/25/2019 BPC 12-01-16.docx
12/28
+se
All
All
-
7/25/2019 BPC 12-01-16.docx
13/28
-
7/25/2019 BPC 12-01-16.docx
14/28
-
7/25/2019 BPC 12-01-16.docx
15/28
-
7/25/2019 BPC 12-01-16.docx
16/28
Help
Formatting and "Use" Column:
Priority to Row or Column
Inner or Outer Dimension:
n the !"###! and !La$el! cells% de&ne the format you want $y using the standard 'icrosoft O(formatting functions+,*###D,-y default% all the format settings are applied and !ALL! is displayed in the !.se! column+,*###,*###D,/ou can then specify which settings of the de&ned format you want to apply or de&ne additionadou$le1clic2 in a !.se! cell and de&ne the format settings in the dialog $o* that opens% or direcformat settings in a !.se! cell% using a speci&c synta*% for e*ample: 3Font-old 4 /5 6 3FontSi7e 4
0hese options ena$le you to specify which one of the de&ned formats for rows or for columns win case of con9icts+ hen you clic2 the !Priority to Column! option% the !Column! section is dispformatting section and the !Row! section is displayed in second position in the formatting sectprecedence rules apply+
f a row or column a*is contains more than one dimension% you can specify which dimension yoformat to $e applied to; !nner dimension! $eing the last dimension% Outer dimension! $eing ththe a*is+
-
7/25/2019 BPC 12-01-16.docx
17/28
-
7/25/2019 BPC 12-01-16.docx
18/28
-
7/25/2019 BPC 12-01-16.docx
19/28
-
7/25/2019 BPC 12-01-16.docx
20/28
-
7/25/2019 BPC 12-01-16.docx
21/28
-
7/25/2019 BPC 12-01-16.docx
22/28
-
7/25/2019 BPC 12-01-16.docx
23/28
-
7/25/2019 BPC 12-01-16.docx
24/28
-
7/25/2019 BPC 12-01-16.docx
25/28
Plan
CFL
Sooper Saltish Click
SALES QUA!"! 2010$an 2011 20000 20000 20000
%eb 2011
&ar 2011 30000 30000 300000
Q1 2011 '0,000 '0,000 320,000
Q2 2011 2',000 2',000 2',000
Q3 2011 (0,000 (0,000 (0,000
Q) 2011 '',000 '',000 '',000
2011 210,000 210,000 )(0,000
201* 110,000
S+ 1'',000 1'',000 )2',000-.n/ 201* 2 2 11
-
7/25/2019 BPC 12-01-16.docx
26/28
!otal ro+cts
0000
30000
)20,000
*',000
2)0,000
1',000
00,000
110,000
*3',0001(
-
7/25/2019 BPC 12-01-16.docx
27/28
CFL
Plan
-
7/25/2019 BPC 12-01-16.docx
28/28