This content has been marked as final. Show 2 replies
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.