43 Replies Latest reply: Apr 15, 2011 7:13 AM by Deepak Kurup RSS

    Adding a Field in a Group(Cyclic) to display latest two weeks

      Hi

      In one of my pivot table I have a group called as Time. Which contains fields such as =Week(date),=Year(date),=WeekName(date) and =MonthName(date). With that I want to one more fields which calculates only 2 weeks of data. It should show latest 2 weeks date only.

      I tried something like =Date(Max(date)-14) but it didn't work.

      Can some one help me out on this please.

      Thanks

      Rikeb