Slice with unique values in a template

[rodlaguapa]

Hi,

Thanks in advance for your help.

I am trying to create a XLSX template with list of unique e-mails of actors that are pending some sort of actvitivy. I have a table named "Monthly_Tasks" and created a slice named "PendingActions" with the following filter: "AND(IsBlank([TSK_Completion-Date]),NOT([PER_ID].[PER_Closed]))", meaning I am filtering every action which completion date is not filled for every period not yet completed.

One of the field in table/slice if the e-mail of the actors. 

I would like to compile a list of unique e-mails of every actions regardless of how many actions each of them are still working with and pass this list to a bot, aiming at running this every morning to so some reminders can be sent to them on a regular basis.

Does anyone have any clue ?

Thanks again,
Rodrigo