I need to show the raw data in different formats.

In the first sheet, a web application will fill the raw data based on the
filtering criteria. The second sheet will show the raw data in different
format with rich formatting applied. There will be some formuae applied to
show summation, percentage etc.

I found that pivot table does not give the look and feel which I require.

Can some provide the solution for this.