PowerPivot Table Selection to a New Table

[gmazza76]

Good afternoon,

I have filtered data in a current PowerPivot Table that I to do separate calculations etc.. on.
Is there anyway to get this data into a new Table in the current existing PowerPivot Tables?

Sorry if this sounds simple, but would I need to write an sql query and if so whats the best way?

thanks
Gavin