Thanks for the detailed explanation!

I am still missing something...

It my user whant to see a crosstab report of NetPrice Amount by Month by Product - how the Columnstore index helps?

It still will have to match Date with Product with NetPrice at the ROW level - so it can aggregate that in March 2015 the revenues from Chairs were 20,000$

I probably missed something...

Thanks,

Michael