2 Replies Latest reply: Feb 9, 2011 1:13 PM by mmazelei RSS

    show all row in pivot table even if other dimension is limited

      hi,

      i try to do something

      i have data depends on 2 dimensions

       

      Taskmonthdata
      Task110
      Task310
      Task120
      Task220
      Task130
      Task230
      Task140
      Task211
      Task321
      Task331
      Task241
      Task341

      first case, i try to show all tasks for each month in pivot table even if datas for task1 is null for each month.

      this case is my first pivot table

       

      second case, i try to limit number of month shown but i would like see all tasks too.

       

      this case is my second pivot table