How to Not include Current Week in my set Analysis

jamiemcc — Sat, 16 Nov 2024 19:28:26 GMT

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

Re: How to Not include Current Week in my set Analysis

lironbaram — Thu, 12 Dec 2019 12:28:14 GMT

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)

topic Re: How to Not include Current Week in my set Analysis in App Development

How to Not include Current Week in my set Analysis

Re: How to Not include Current Week in my set Analysis