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?

[soniasweety]

the way how i want will not get

[soniasweety]

No didnt helped

[arvind_patil]

I think that is the solution  ,

otherwise you have to create  Straight table and create set analysis for each year.

Thanks,

Arvind Patil

[soniasweety]

jyothish8807‌

aliahmed89‌    tresesco‌   felipedl‌

[jyothish8807]

Hi Sony,

In this case use "Order Type" as dimension, and then create two expression "A" and "B".

Br,

KC

[soniasweety]

attaching sample

how can i do this?

[soniasweety]

still no luck sir

[jyothish8807]

Check my sample attached above.

[soniasweety]

thanks  let me try in my original app and get back to you 

[jyothish8807]

Check this sample:

Br,

KC