1 Reply Latest reply: Oct 31, 2011 12:45 AM by Kiran Rokkam RSS

    How to show dimension in Pivot table?

    isaac li

      Hi,

       

      I have one question:

       

      There is one dimension called DimTime, the structure of it looks like this:

       

      Year-Month,Week, Date

       

      2011-01,Week1,2011-01-01

      .

      .

      .

       

      Now I want to show it in one pivot table,

       

      I want to show them not just based on layer, the results:

       

                       Year-Month  Week

      Metrics       10               3

       

      Can we achieve it? It means Year-Month and Week are shown in on Pivot table without drill down.

       

      Thanks.