1 Reply Latest reply on Apr 30, 2013 10:06 AM by Tracy Rodgers

    Displaying last x weeks without including the current week

    brunovais0

      Hi,

      I have a worksheet that displays price counts per week. Each bar is a week. Each week the clients would login and view data for the previous weeks.

      How can I prevent the chart from displaying the current week without hard-coding anything? I tried using the Date as a filter, but the "Last x weeks" will include the current one.

      Is there perhaps a formula I could use (something along the lines of a "week - 1") or something?

       

      tnx