Excluding dates from pivot table

[EMRSD]

I've created a pivot table and I do not want the columns with weekend dates to display. How would I remove them? ( I don't care if there is data on the weekend dates so I don't want them to show)

-thank you

[Vegar]

what if you load an weekend flag when fetching the data.

Load Employee, Amount,  Date, if(weekday(Date)>4, 'Yes','No') as isWeekend From Source;

Then you can either select No From your isWeekend field to only display the business week days.

You could also use it in the expression with set analysis.

Sum({<isWeekend ={'No'}>}Amount )