I need to get the last value stored for each month, displaying month name as column header

I'm trying to get this result using ClosingPeriod function but I can't do
it, as I get only 1 value from ClosingPeriod.

This is the MDX query I'm using:

{ClosingPeriod(Time.[Day],Time.CurrentMember)} ON COLUMNS,
{Product.Category.Members} ON ROWS
FROM [StatProd]

I need to obtain a result like this:
Jan Feb Mar ....
product1 10 12 9
product2 37 44 25
product3 14 2 10

where values are last stored value for each month

Thanks in advance for help