on 07-03-2013 1:18 PM
Hi Guys
I have a scenarios as below
SerialNumber | Type | Value | Delivery |
---|---|---|---|
1111 | IMEI | 22222222 | 3434343 |
1111 | mobile | 33333333 | 3434343 |
Need to code logic in webias below
Serial | IMEI | MOBILE | DELIVERY |
---|---|---|---|
1111 | 222222222 | 333333333 | 34343434 |
Is this possible .. i tries but never seems to ..it comes with blank as below
Serial | imei | mobile | delivery | |
---|---|---|---|---|
1111 | 22222222 | 34343434 | ||
1111 | 333333333 | 34343434 |
Hi dd,
Please use the below logic for the Columns IMEI and Mobile and leave the other columns as is, and you would get then as expected. Please see below sample where it was achieved with similar data set.
IMEI Column=[Value] Where([Type]="IMEI")
Mobile Column=[Value] Where([Type]="mobile")
Thanks
Mallik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would recommend having two similar queries. One would have a query filter where Type = IMEI and then other would have a query filter of Type = mobile.
Then in your report you would create a merged dimension on Serial by right-clicking on Serial from each query and choosing "Merge". Put that merged dimension on your report with the value from each query.
Read this blog post for some background on merged dimensions and some of the potential issues you may encounter.
http://michaelwelter.wordpress.com/2011/04/18/tips-for-merging-dimensions/
Hope this helps,
Noel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.