Help needed on Line chart

[#1]

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9	Header 10
Share	X	Y	Z	A	B	C	D	E	F
Share1
Share2
Share3
Share4
Share5
Share6
Share7
Share8
Share9

Hey I want my line chart to be in the way that Share1 to 9 falls on X-axis and I have the option to select either X or Y or all(as many as i want). My X,Y,Z,A......F are my Drugs.

What I did:

I placed my share in dimension and in expression i added Only(X), Only(Y)......Only(F). Now i am getting the line chart but I am not able to select drugs on my choice. Kindly help me.................

Thanks in Advance

Regards

Sagar Gupta

[pover]

It would be easier if you can change your table to the following structure:

Share     Drug     Value

1            X          10

1            Y          7

2            X           8

Karl

[#3]

Thanks Karl,

I also did the same

🙂

Sagar

[#4]

Hey Karl,

Its working and I would like to know if there is any other way to do it.

Sagar

[pover]

Hi Sagar,

No.  You either create an expression for every Header or you do a crosstable function to rotate the columns into rows and leave it in the format that I posted above.  I prefer the second option.

Karl