How do I Display Location columns in my Task Report macro?

Question

How do I Display Location columns in my Task Report macro, currently, it is showing only these 4 columns (Description, Due Date, Assignee & Task Appears on), I want to add a region-wise filter so that I get the task list for (EMEA, JAPAC, AMER etc..).

Please assist me acccoridngly.

Regards,

Srinivas Musale

Alex Koxaras -Relational- · Answer

No you can't add another column, besides the one that states under that field. You could use the LABEL field to add your region there. And then add the LABEL to your columns.

Alex

Srinivas Musale · Answer

Hi Alex,

Thanks for your response. Yes, I know the default fields. Please refer to the below-attached screen prints for your reference.

please confirm, is there a way I can insert a new column called "Region" after the "Assignee" column? I want the data to be shown as per Region. Also, how do I extract the field value of  Region?

Please assist.

Regards,

Srinivas Musale

Alex Koxaras -Relational- · Answer

Hi @Srinivas Musale and welcome to the community,

Add any field you want on the "columns to display" field. Kindly see the following image:

Location is the page which the task appears. It has nothing to do with geographical location. In addition, allowed columns are description, duedate, assignee, location, completedate, labels.

Hope that helps,
Alex