Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a straight table. I am using two dimensions in the table. It is resulting in one row for each dim1 dim2 combination.
For eg, If my first dimension is X (which contains a,b,c), and the second is Y (which contains 1,2,3), I am getting a table as follows
a 1 ................
a 2 ................
a 3 .................
b 1 ................
b 2 ..................
b 3 ...............
c 1 ..............
c 2 ...............
c 3 .................
I would like to see my result in the following form:
1 2 3
a .. .. ..
b .. .. ..
c .. .. ..
Can somebody plz tell me if I can do this without using a pivot table? I also don't want to use separate expressions for each value of Y. Thanks
Update new
As you say without pivot and do not want to write many expression then you have to use only pivot from my suggestion see when your value increase in the Y dimension then you have to write more expressions which need to avoid. You can use pivot table for this and then select Y dimension and drag it towards the right upper corner then you see the blue arrow mark when it is convert into horizontal leave your dimension there.
See the snap some thing like below image
Without using a pivot table?
Hm, You can create several expressions instead the second dimension, one expression for each dimension value (needs manual maintenance), limiting the records to the fields values '1','2','3' withing the expression (using if() statement or set analysis).
edit: I've overseen your last sentence. No, I don't think it's possible then.
Either
Use Pivot Table
or
use Straight Table with Several Expressions and using if or set analysis
Yes Swuehl is write you have to write many expression for every condition in SET of if condition like
Dimenion:- X
Expr1:-sum({<Y={'1'} >} sales)
Expr2:-sum({<Y={'2'} >} sales)
Expr3:-sum({<Y={'3'} >} sales)
If you use Pivot and straight see the snap for difference
Like this ?
Hi,
Create the same in Pivot chart with 2 dimensions.
Darg the 2 nd dimension to top.
Hope this is helpful.
Regards,
Joshmi