Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    60

    Unanswered: Period Dimension in excel pivot tables

    Hey Guys,

    I have a cube with a Period Dimension, in which the hierarchy is as follows:

    Year
    Quarter
    Month
    Day

    Users access the data via a pivot table.

    The problem is that whenever a new month comes in, the pivot table doesn't automatically display data regarding the new month. Can someone please help me here.

    Thanks,

    Surbha

  2. #2
    Join Date
    Jul 2004
    Posts
    4
    Try going into table layout, double click on the time dimension and check mark "Show items with no data."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •