3 Replies Latest reply: Sep 1, 2011 5:03 AM by Koushik Roy RSS

    Pivot table with some dimensions expanded.

      Dear All Friends,

                              Can I create a pivot table where some dimensions are expanded but not all dimension.

                              Suppose there are 5 dimensions..

                              1.Month

                              2.Location

                              3.Sale Type

                                4.Sale No

                                and 5.Sold Qty.

      I want to show only 1,2 in expanded mode and 3,4 and 5 in pivot mode.Its depends on user to pivot or not.

       

       

      Please Help me its urgent.Waiting here for your fast response.

       

      Thanks & Regards,

      Koushik.