pivot table two dimensions see in single row

[kulasekhar]

Hi All,

In pivot table i have two dimensions like bellow.

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.

[kulasekhar]

Hi Anil,

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

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

2)Expresstions: =MaxString(MODULE)

Thanks

Sekhar.

[Anil_Babu_Samineni]

Copy the script and use pivot table dimension as LEVEL1 and expression. let's see how this works. Or you may share sample in real data

[kulasekhar]

Hi Anile,

Please find the bellow XL File. That file I have null(#N/A)values. How can i remove.

Thanks

Sekhar.

[Anil_Babu_Samineni]

May be use this

LOAD * From <Excel> Where Len(MODULE)>0;