How to show dimension in Pivot table?

[#1]

Hi,

I have one question:

There is one dimension called DimTime, the structure of it looks like this:

Year-Month,Week, Date

2011-01,Week1,2011-01-01

.

.

.

Now I want to show it in one pivot table,

I want to show them not just based on layer, the results:

                 Year-Month  Week

Metrics       10               3

Can we achieve it? It means Year-Month and Week are shown in on Pivot table without drill down.

Thanks.

[#2]

Hi Isaac,

I am not sure what you meant by without drill down, but you can try this as following:

Straight Table:

Dims: Year-Month, Week

Express: Metric

Properties->Presentation->Horizontal (Check)

Its not pivot table but I think this is what you need.

Hope it answers you question.

Kiran.