Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a Pivot table that i need to Remove the current Week and Only show the last max Week and Previous weeks
Sum({<DailyTaskType = {'Counts'}, Tier = {'Tier 1', 'Tier 0'}>} Tasks)
I tried the below and it hides current Week Okay but when i select a certain week It used that as the max week and Hides it. I need to be able to select a week.
Sum({<DailyTaskType = {'Counts'}, Tier = {'Tier 1', 'Tier 0'},Week = {">=$(=Max(Week)-10)<$(=Max(Week))"}>} Tasks)
Jamie
hi
you'll need to put a more advanced condition for finding the max week
something like this
Sum({<DailyTaskType = {'Counts'}, Tier = {'Tier 1', 'Tier 0'},Week = {">=$(=Max(Week)-10)<=$(=if(Max(Week)=week(Today()),Max(Week,2),Max(Week))"}>} Tasks)