Showing criteria in export

[DaveStraw]

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 · Accepted solution]

Hi @DaveStraw 

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]

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

[DaveStraw]

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