1
a
Sub A
Sub B
2
a
Balance
1
2
3
a
P&L
3
4
4
a
Shares
2
1
5
a
Dividends
1
2
1
b
Sub C
2
b
Balance
2
3
b
P&L
3
4
b
Shares
1
5
b
Dividends
4
1
c
Sub D
Sub E
2
c
Balance
2
4
3
c
etc....
2
3
RecordID
NewName
V_String
100
Empty
IF [RecordID] =1 THEN Value Else [Row-1:NewName] ENDIF
Create the "Sub" names we need for cross tab
IF [RecordID] =1 THEN Value Else [Row-1:NewName] ENDIF
Warn
Transpose so that F3 and F4 data is in one column
!IsNull([Value])
Simple
IsNotNull
Value
True
fixed
2019-01-11 09:41:19
0
2019-01-11 09:41:19
2019-01-11 09:41:19
!IsNull([Value])
,
Cross tab actual data
Create Non-entity name data
RecordID
1
Int32
6
0
Warning
All
ByName
#1
#2
C:\Users\claje03\AppData\Local\Temp\Engine_18072_7f6625b92bec48ee8cae44c593640007_\Engine_8540_d4372fcd0f9b492cbaf3202226986c60_.yxdb
Single
Profile
Create Entity Name data
,
Cross tab actual data
Horizontal
claje_verticalreporting
claje
2018