straight table

[manoj217]

Hi All,

I have a straight table consisting of 15 dimensions and measures , I have taken one expression as =Field name.

Data will be like this:

Dimension1, Dimension2,Dimension3,Measure(=Field name)

a,x,1,100

b,y,2,100

c,z,3,200

a,x,2,100

in this above condition its works fine but if I omit Dimension3 it has to show like this.

Dimension1, Dimension2,Measure(=Field name)

a,x,100

b,y,100

c,z,,200

a,x,100

but it is showing

a,x,100

b,y,100

c,z,,200

[sunny_talwar]

Check my response here

straight table

[gerry_hdm]

Rownr()

the qou see all

[gerry_hdm]

start:
load * inline
[ Dimension1,Dimension2,Dimension3,Measure
a,x,1,100
b,y,2,100
c,z,3,200
a,x,2,100
]

;
END:
load *,
Rowno() as visible
  resident start;
  drop table start ;

[qv_testing]

HI,

I think you have to use Sum(Measure) 

Dimension1	Dimension2	=Sum(Measure)
Total		500
b	y	100
a	x	200
c	z	200

Table and Straight table shows only unique records.

If you take RowNo(), that will take sequence, 1,2 ,....and so on

use like

Load *, RowNo() as Key;

Load * inline  [

Dimension1, Dimension2,Dimension3,Measure

a,x,1,100

b,y,2,100

c,z,3,200

a,x,2,100

]

Thanks..

[gerry_hdm]

greetings Gerry

[manoj217]

I don't want to add another dimension into the straight table

[qv_testing]

Take all dimensions and measure in Straight table

goto  ---> presentation tab ---> select Dimension3 and Hide the column

Hope this works..

[gerry_hdm]

hide is not work  in a straight table 

you use the Diagramm box  the you can use the Hide for the Dimension 3

gruß Gerold

[gerry_hdm]

hide is not work  in a straight table 

you use the Chart box  the you can use the Hide for the Dimension 3

gruß Gerold