topic Re: Showing criteria in export in App Development

Showing criteria in export

DaveStraw — Thu, 23 Jan 2025 08:35:13 GMT

Is there a way to show the criteria and filters that were used to generate the export. I believe this was something that was available at some point.

I have tried to use =GetCurrentSelections() which does spell out the criteria but this is not present (as far as I can see) when exporting.

Thanks in advance!

JandreKillianRIC — Thu, 23 Jan 2025 13:34:28 GMT

I assume this is a export to excel.

If this is a Image - You can add it in the Subtitle

If this is excel (Not a pretty example but it works)

I would add a measure and move it to the front (First Column)

=IF(RowNo(Total) = 1, GetCurrentSelections(), '')

Excel Result

Or just add it as a Measure, at the end with a calculation of =' ' (Equal to a space) and in the lable expression do this

='Report Selections: '&IF(Len(GetCurrentSelections()) = 0, 'None', GetCurrentSelections())

The result would look like this

Excel

Regards - Jandre

DaveStraw — Thu, 23 Jan 2025 13:33:44 GMT

Thanks for the reply, I'll have a look into this and see if I can get it working

DaveStraw — Thu, 23 Jan 2025 14:07:36 GMT

Hi @JandreKillianRIC, I've got it working correctly and exporting for a table but any ideas for a Pivot table?