How to Not include Current Week in my set Analysis

[jamiemcc]

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

[lironbaram]

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)