Same

[smilingjohn]

Hi All,

PLease find the attachment of the sample qvw

I have two leveles Level1 and Level2

I have two charts straight table and pivot table ..

If u look at the straight tabe the way IND or LND ...is diplayed for each level

where as for Pivot it is not displaying .

Cant i make Pivot table to appear in the same way as that of Straight table ?

[adamdavi3s]

Hi John,

Could I just ask why?

There isn't a simple option to do this but I am sure a workaround can be found somehow, but I don't really understand quite why you would want to do this

[smilingjohn]

Becuase  i will be having a month column which i will be taking as horzontal by draging it up ,thats why i need pivot table

Thanks

[awhitfield]

Same again why do you want to do this?

[smilingjohn]

Hi Andrew

I have a month culumn as dimension , and i need to show month names horizontally , i do this by draginging the month column horizontally on the top header , which is not possible in Straight table .

Thats the region i want to achieve this in pivot table

[vinieme12 · Accepted solution]

Yes you can make it look that way !

Try as below

Change it to a calculated dimension

Dimension1:  =Leale1&chr(10)& Level2

Dimension2: =Level2