How to make this chart

[#1]

Hi guys,

	A	B	C	D	E = Total(A + B + C + D)	F	E + F
P	1	1	1	1		1
Q	2	2	2	2		2
R	3	3	3	3		3
S	4	4	4	4		4
T	5	5	5	5		5

A, B, C, D, F -> are coming from one field so it is dimension.

P, Q, R, S, T -> are derived fields so i am using as expression.

How to achieve E which is derived and E+F

Plz help

Thanks.

[Gysbert_Wassenaar]

A, B, C, D, F -> are coming from one field so it is dimension.

Create a new field from that in a new table:

NewTable:

LOAD * inline [

Field1, NewField

A, A

B, B

C, C

D, D

A, E

B, E

C, E

D, E

A, G

B, G

C, G

D, G

F, F,

F, G

];

Then use NewField as dimension in the chart instead of Field1.

[#3]

Thanks.

And if some of the value i dont want to see in new field how can i achieve that ?

[rajeshqvd]

simply put Column(1)+Column(2)+Column(3)+Column(4) for E and Column(5)+Column(6) for E+F

[rajeshqvd]

use set analysis and filter what  you want

[Gysbert_Wassenaar]

Leave them out.