Expanding and collapsing to show totals and subtotals

Hello,

I have a transactional cube where I want to show data in Web Interface .A cross-section of the data :

Company Account Year Period Cost

-

SAP ACC001 2005 1 100

SAP ACC001 2005 2 100

SAP ACC001 2005 3 100

SAP ACC001 2005 4 100

SAP ACC002 2005 1 100

SAP ACC002 2005 2 100

SAP ACC003 2005 3 100

SAP ACC004 2005 4 100

So the requirement is that the user should be able to see total for an account (say ACC001) .So my idea is that if I can allo the user to expand and collapse on the account so that he sees the data something like this ..

Company Account Year Period Cost

-

SAP ACC001 2005 # 400

Any help would be greatly appreciated.

Thanks in Advance,

Priyadarshi