Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn
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
Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn
Thanks for the reply, I'll have a look into this and see if I can get it working
Hi @JandreKillianRIC, I've got it working correctly and exporting for a table but any ideas for a Pivot table?