Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 )