2 Replies Latest reply: Sep 15, 2011 5:58 AM by Erika Jain RSS

    Pivot Table report

      Hi All!

       

      I need some Help..

       

      I have attched a sample Excel file.

       

       

      What I need is ...

      I want to display Policy No. whose Gross Claims is greater than 50 Lacs.

       

      I need a Pivot table in which Policy No. is being shown as Dimension and Expression is Gross Claims Gretaer than 50 lacs.

       

      When I expand the table The second Dimension is Claims Nos. ,

      when Pivot is Expandted upto Claim level then the Amount should be distributed Accordingly.

       

       

      Plz help...:(