Help on Aggr

[#1]

Hi,

Attached is the file with two table Fact and Component. A different part number in the Fact could have the same component, each component has its own High or Low value.

I will need to present the details as well as summary table, the summation of the Amount in the Summary table will have to match with that of total amount in the details table.

I guess Aggr function could help.

[anbu1984]

Check my solution above works for you

[#3]

Thank you Santosh, your solution worked on the data set..

[#4]

Thank you Santosh, your solution worked on the data set..

[#5]

same as Santosh solution.. worked for me. Thank you!@