how to create a percentage line

[#1]

Hi,

I have the following chart.

I need to create another line that represents 'Planned' as a percentage over 'total 40f'.

Please assist.

thank you so much

grace

[sunny_talwar]

Are you using 2 dimensions and 1 expression or 1 dimension and 4 expressions?

[#3]

Hi. I'm using 2 dimensions and 1 expression.

[sunny_talwar]

Would changing to 1 dimension and 4 expression (actually 5 when we add the fifth line) something which would work? if not, then would you be able to provide a sample?

[#5]

Hi,

I am not sure how to change it to 4 expressions. The only expression that I have now is ‘Boxes’.

The data that I have is very raw.

The 1-7 being the months and the figures are ‘boxes’

Thanks

Type

1

2

3

4

5

6

7

Total 40ft

40,488

39,150

31,812

36,340

37,248

38,602

21,142

T40_Opportunities

23272

20605

13947

15148

17636

19448

11026

Planned

6,704

6,191

1,922

2,988

6,441

6,612

5,272

Executed

1,736

1,446

1,142

1,976

3,846

4,134

3,002