

SELECT 
{Hierarchize(Crossjoin(Union({[Products.defaultHiera].[All Products].[Classic Cars]}, {[Products.defaultHiera].[All Products].[Motorcycles]}, {[Products.defaultHiera].[All Products].[Trucks and Buses]}, {[Products.defaultHiera].[All Products].[Vintage Cars]}), Union({[Time.defaultHiera].[All Time].[2013]}, {[Time.defaultHiera].[All Time].[2014]}, {[Time.defaultHiera].[All Time].[2015]}, {[Time.defaultHiera].[All Time].[2016]})))} on columns,
{Hierarchize({[Measures].[Price]})} on rows
FROM [Sales Analysis]
