SELECT [Measures].Members ON COLUMNS,
NonEmptyCrossJoin([Store].[Store State].Members,
[Product].[Product Family].Members) ON ROWS FROM Sales

result:

CA drink 11111 usd
food 22222 usd
non-cons 33333 usd
OR drink 11111 usd
food 22222 usd
non-cons 33333 usd

I need

CA drink 11111 usd
food 22222 usd
non-cons 33333 usd
sum CA 66666
OR drink 11111 usd
food 22222 usd
non-cons 33333 usd
sum OR 66666
sum ALL 133332