Horizental above

[soniasweety]

Hi all,

i have a pivot table  with the  dimension  

Ordertype

A

B

so now i draggared to top 

the result coming as 

Ordertype     A     B

instead of this i want as

Ordertype

A     B

how can i do this?

[arvind_patil]

Hi Sony,

Create Dummy Dimension 

_DummyDim:

Load * Inline[

_OrderType

Ordertype

];

DATA:

Load * Inline [

Ordertype

A

B

];

Add in pivot table you will get as you want.

Thanks,

Arvind patil

[soniasweety]

if i use the dimension how it will show in pivot table as that  way ?

[soniasweety]

for example

year i have   

year  2010 2011 2012

now i want

      year

2010   2011 2012

[arvind_patil]

Hi Sony,

I think  You need to use year as column only.

and Customer as row .

Thanks,

Arvind Patil

[balabhaskarqlik]

I don't think so, value will come like that.

[arvind_patil]

Create dummy dimension  _Year with value Year and use it as row

Thanks,
Arvind Patil

[soniasweety]

its not working

[soniasweety]

any other alternate for this?

[arvind_patil]

She will get extra column like year but value is null in that.

Thanks,

Arvind Patil