pivot table two dimensions see in single line.

[kulasekhar]

Hi All,

In pivot table i have two dimensions like bellow.Please find the attached sampule data XL.

I want see one  ITEM NUMBER(61195643-54) one module Like bellow images.

        

I Want see any MODULE in one row. like above any one.

Thanks

Sekhar.

[sunny_talwar]

You want this?

Script used

Table:

LOAD [ITEM NUMBER],

     MODULE,

     [USED ONLY IN GREY SPECS?],

     [SPECIFICATION NUMBER]

FROM

[..\..\..\Downloads\MODULE.xls]

(biff, embedded labels, table is Sheet1$);

FinalTable:

LOAD *,

  If([ITEM NUMBER] = Previous([ITEM NUMBER]), RangeSum(Peek('SNo'), 1), 1) as SNo

Resident Table

Order By [ITEM NUMBER];

DROP Table Table;

Pivot table

Dimensions

ITEM NUMBER

SNo

Expression

MODULE

[kulasekhar]

Hi sunny,

I want bellow  two rows (ITEM NUMBER AND 1). No need third row(2).

Thanks

Sekhar.

[sunny_talwar]

So may be just this

[kulasekhar]

Hi Sunny.

It's working belloe both Expresstions but showing Null values.

1)Expresstions: =Only({<SNo = {1}>} MODULE)

2)Expresstions: =MaxString(MODULE)

Thanks

Sekhar.

[sunny_talwar]

They are working but showing Null? What does that mean?