T:\BEMI\Alteryx\Solutions\Pivot Table by Month\Pivot Table by month.xlsx|||`Data$`
False
1
Pivot Table by month.xlsx
Table=`Data$`
Warning
All
ByName
#2
#1
C:\Users\danilang\AppData\Local\Temp\1\Engine_8864_08250c3eac494d8991b11186e376baa7_\Engine_6220_7790bf20be814d10884a271d34595e16_.yxdb
Single
Profile
Grand total
Warning
All
ByName
Total row
Total Row = "Grand Total"
Month = if isnull([Month]) then
"Grand Total"
else
[...
Line items
[Category] = "Fruit"
Simple
=
Category
True
fixed
2018-10-15 07:32:15
0
Fruit
2018-10-15 07:32:15
2018-10-15 07:32:15
[Category] = "Fruit"
[Category] = "Fruit"
Simple
=
Category
True
fixed
2018-10-15 07:36:10
0
2018-10-15 07:36:10
2018-10-15 07:36:10
Fruit
[Category] = "Fruit"
Warning
All
ByName
#1
#2
#3
#4
Sub Total
[Category] = "Fruit"
Simple
=
Category
True
fixed
2018-10-15 07:42:51
0
2018-10-15 07:42:51
2018-10-15 07:42:51
Fruit
[Category] = "Fruit"
[Category] = "Fruit"
Simple
=
Category
True
fixed
2018-10-15 07:43:04
0
Fruit
2018-10-15 07:43:04
2018-10-15 07:43:04
[Category] = "Fruit"
Warning
All
ByName
#2
#1
#4
#3
Horizontal
Pivot Table