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...:(