How to give common name in pivot table?

[Shubham_Deshmukh]

I am using pivot table ,this is what I am doing

What I want is,

Pls help

[Shubham_Deshmukh]

This is what I am doing

This is what I want

Where Apr,May,...... is my dimension

A,B,C..........Expression working row-wise

Also, I have done this thing in another situation in which I was dealing with calculated dimensions (eg: valuelist(a,b,c))

But here I have fixed dimension according to date field.That's why I am facing this issue

[prat1507]

Ok, and here are you using a single expression or multiple expressions?

Regards

Pratyush

[prat1507]

Can you provide me the script you're using for the above pivot table?

Regards

Pratyush

[Shubham_Deshmukh]

Multiple expression

A is my exp1

B is my exp2.........

My SQL script is pulling out some data.

Dimension =months, which I dragged horizontally to use them as a column.

And expressions are like

A= count(ID)

B=count(If(condition) , tID) ......................................so on.

[prat1507]

Ok, thanks for your patience.

Create an inline table as mentioned before

Tab1:

Load * Inline [

Type, Expr

Marketing, A

Marketing, B

Marketing, C

Digital, Digital1

Digital, Digital2

];

Further create a pivot table

and add dimensions as :

1. Type

2. Expr

3. Months

Drag Months field to the top:

Create a single expression and type there:

pick(match(Expr ,'A','B','C','Digital1','Digital2'),

Expr_A,

Expr_B,

Expr_C,

Expr_Digital1,

Expr_Digital2

)

Expr_A, Expr_B, ...... are the expressions for A, B, C, Digital1 and Digital2 consecutively.

Regards
Pratyush

[Shubham_Deshmukh]

Hey, thanks for your help.

but that's what I said earlier. I have done this before as you said.

I was asking about, is there any other solution so  that by taking dimension or something else.

btw thanks Pratyush for your help and attention.

[Shubham_Deshmukh]

Then also I will try this for self learning.Thanks.

[prat1507]

No problem, sorry couldn't help you out

Regards

Pratyush

[Shubham_Deshmukh]

Hey Its' ok no problem.

[Shubham_Deshmukh]

Btw Piyush,I tried your solution but it's not working , I think due dimension of month it's not working.

Bcoz  I done such report of bit different pattern where there wasn't any direct dimension.