Aggregation like Pivot table in Excel

[dphigravity]

I know this might be a simple question but I am having a hard time finding the solution. In an example where I have fields State, Product, Sales Price, and Qty and I want to add calculated fields to my table (e.g. Revenue= Sales Price x Qty by Product), I can do that within one view. But if I want to see a visual on an aggregation of the Revenue by State, it would seem like I need to either create another view where I do a subquery or do some kind of derived table. Is this the only way to do this?

Thanks!