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