I have tried it a couple of different ways but none of them seem to work. I am trying to find a way using JSL to create a stacked data table but only with the rows I have selected. I am using the JSL inside of a Workflow.
Data Table( "My Table" ) << Clear Select <<
Select Where( :Name("5 Million") == "Over 5 Million" ) <<
Stack(
columns(
:"Baseline Percent Change"n,
:"District Percent Change"n,
:"Engineers Percent Change"n
),
Source Label Column( "Estimate" ),
Stacked Data Column( "Percent Change" ),
Drop All Other Columns( 1 ),
Output Table(
"Stack of Fiscal Year 2024 Percent Changes - Over 5 Million)"
),
selected rows only(1)
)
Any help is greatly appreciated.