is it possible to add the column selector in the footer of a custom report? I created a transaction report (tried all ; summary, matrix, detailed) but cannot seem to figure out how to have the column selector that is available in the footer of standard reports.
k
KevinJ of Kansas
03/23/2021, 8:56 PM
Do you mean the thing that lets you pick how you split the columns (i.e. period, subsidiary, location etc)? I only recall ever seeing that on financial reports.
k
kyle
03/23/2021, 9:00 PM
yeah that thing
kyle
03/23/2021, 9:01 PM
in a custom report i can set a static column if i choose matrix, but cannot seem to be able to switch the column on same report like you can with oob reports
k
KevinJ of Kansas
03/23/2021, 9:03 PM
That matches what I'm seeing
k
kyle
03/23/2021, 9:03 PM
thx
k
KevinJ of Kansas
03/23/2021, 9:03 PM
I didn't realize that was available on non financial reports anyways.
KevinJ of Kansas
03/23/2021, 9:03 PM
You might be better off taking a OOB report and modifying that if you can include the desired records in the report