Pivot Table report

[#1]

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

[SunilChauhan · Accepted solution]

please see the attached file

hope this helps

[#3]

Hi Sunil!

Thanks for all ur help.

But actualy I think I was not able to explain my problem properly.

But I Have got the solution.

Thnks once again.