try like this:
1.Add one list box for the company so that when you select a company you will get the records details.
2.Add company dimension in the Pivot table so that it will be help full.
3.If you do not have the company details in the DB then while loading try like this
Load 'Company1' as company name,
Load 'Company2' as company name,
Hope this helps you