Use hidden information for filtering data

Question

When I filter information - let's say I want to see only Panasonic computers. Is it possible that information begin from 1 to 1000? NOT 1,12,13,14,50,57,100. Because in my case, hidden information doesn't let me use formulas from other sheet.

Answer 1

I used pivot table as Matt said :)