5 Replies Latest reply: May 17, 2013 11:51 AM by Gaurav Malhotra RSS

    Calendar for current_month and prior_month - dimension

    Friedrich Hofmann

      Hi,

       

      on one sheet in my current document (base for a report), I have two pivot tables representing a calendar: One for the current month and pme for the prior month.

      The trick is, the dimensions are  "week" (vertical) and "workday" (horizontal) - but currently, on the calendar for the prior month, the weeks of the prior month AND the current month are visible, only the formulas are calculated only for the prior month.

      How can I edit that diagram so that the dimension "week" is limited to the weeks of the prior month?

      Thanks a lot!

      Best regards,

       

      DataNibbler