Select most recent month's actuals and export as one tab per charge code
Custom
C:\Users\ABHILA~1\AppData\Local\Temp\Engine_12932_8065ef608a2645aeaa226c71c32fc5e3_\Engine_9144_94208c83ec2d4569bb4ba90e2ef3b690_.yxdb
Single
Profile
C:\Users\ABHILA~1\AppData\Local\Temp\Engine_12932_8065ef608a2645aeaa226c71c32fc5e3_\Engine_9144_aeecd33e4ba7464488dc4234b3e05210_.yxdb
Single
Profile
Project1
Air/Rail
Mar
100
Project1
Auto/Local
Apr
50
Project1
Air/Rail
Apr
200.05
Project1
Accomodations
Apr
1000
Project1
Auto/Local
Apr
50
Project1
Air/Rail
Apr
200
Project2
Air/Rail
Jan
350
Project2
Sundry
Apr
100
Project2
Sundry
Apr
20
Project2
Services
Apr
5000
Project2
Test1
Apr
5000
Project1
Test2
Apr
5000
C:\Users\ABHILA~1\AppData\Local\Temp\Engine_12932_8065ef608a2645aeaa226c71c32fc5e3_\Engine_9144_839720c099dc487b877d57712884693b_.yxdb
Single
Profile
I want this summary in pivot table form (ideally with the ability to refresh once in Excel - aka, as an actual pivot table)
OUTPUT_PATH
OUTPUT_PATH = ".\Actuals tabs.xlsx|||"
+[Project Name]
+"Actuals$A1:D"
+TOSTRING...
RecordID
1
Int16
1
0
Error
C:\Users\AbhilashR\Downloads\Actuals tabs.xlsx|||Actuals$A1:D20
False
False
Overwrite
Path
OUTPUT_PATH
Actuals tabs.xlsx
Query=Actuals$A1:D20
Identifies Max row count for the pivot range
Artificially creates the output path string that is passed into the Output tool
Horizontal
Example_v2