0 Replies Latest reply on Jun 17, 2010 3:05 PM by user530299

    Expansion of Period with 2 cells within it

    user530299
      Hi,
      I have a report where I have Period dimension and Account dimension in the columns. And i have to select two account dimensions and display them within a period as below

      Qtr1
      _________________
      Account X |Account Y

      I have selected the dimensions, and given the Allow Expansion property for the Period dimension.

      But when i expand I need to get the columns displayed as


      >Jan
      _________________
      Account X |Account Y

      Feb
      _________________
      Account X |Account Y


      etc

      but now all I am getting is

      Jan Feb Mar
      _________________
      >Account X




      Jan Feb Mar
      _________________
      >Account Y



      When i expand, I need the cells Account X and Account Y as two split cells within Jan and likewise for the other periods and not as Jan ,Feb,Mar for Account X and Jan ,Feb,Mar for Account Y.

      Is there any way I can accomplish this?


      Thanks