Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using pivot table ,this is what I am doing
What I want is,
Pls help
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
Ok, and here are you using a single expression or multiple expressions?
Regards
Pratyush
Can you provide me the script you're using for the above pivot table?
Regards
Pratyush
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.
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
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.
Then also I will try this for self learning.Thanks.
No problem, sorry couldn't help you out
Regards
Pratyush
Hey Its' ok no problem.
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.