WebI Cross Tab Cell Value

[Former Member]

Is it possible to read the cell value in WebI like excel

2007 2008 2009 Result Column

India 1 2 3 2007-1;2008-2;2009-3;

USA 3 4 5 2007-3;2008-4;2009-5;

UK 5 5 5 2007-5;2008-5;2009-5;

I want to know , How to get the result column in above cross tab..its easy to do in excel just read the cell & concatenate thevalue ..how to do it in WebI

[Former Member]

Unfortunately (due to text alignment), I am not able to understand your requirement.

Can you explain with a sample clearly

[Former Member]

Is it possible to read the cell value in WebI like excel

I--

---

2007

---

2008

---

2009--

---

Result Column

India--

---

1

---

2

---

3--

---

2007-1;2008-2;2009-3;

USA--

---

3

---

4

---

5--

---

2007-3;2008-4;2009-5;

UK--

---

5

---

5

---

5--

---

2007-5;2008-5;2009-5;

I want to know , How to get the result column in above cross tab..its easy to do in excel just read the cell & concatenate the value ..how to do it in WebI

[Former Member]

Omi

it is possible to get the result set in the following format.

I--

---

2007-R C---2008-R C

---

2009---R C--

---

India--

---

1

---

2007-1

---

2--2008-2

---

3--2009-3--

USA--

---

3

---

2007-3

---

4--2008-4

---

5---2009-5---

UK--

---

5

---

2007-5---5---2008-5

---

5

---

2009-5--

Add a column and place this formula

=[Year]" - "[Measure Value](Year is your Column object and Measure value is your measure, insert a + before and after double quotes)

Regards,

Swati.

Edited by: Swathi Padithala on Dec 1, 2009 10:20 AM