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.

[Anonymous]

Do you need only one MODULE for each Item number when expanded?

[aarkay29]

If you want line by line then you have to use straight table instead of pivot table.

[kulasekhar]

Both should be in dimensions.

Thanks

Sekhar

[#5]

By  having Module and Item Number as dimensions and using count in expression for ModuleNo field, the chart could be shown in following format..

[vinieme12]

Here is a workaround I posted for something similar

Same

You can make it look that way

Change it to a calculated dimension

Dimension1:  =ITEMNumber&chr(10)& Module

Dimension2: =Module

[kulasekhar]

Hi Vineeth,

Your shard

LEVEL1 ,  LEVEL2

  ABC     ,aa

   ABC     ,dd

  ABC      ,mm

I want singile row like bellow

LEVEL1 ,  LEVEL2

  ABC     ,aa

    ( or)

   ABC     ,dd

     (or)

  ABC      ,mm

Any one row. If there any pasibulities.

Thanks

Sekhar.

[Anil_Babu_Samineni]

What is the logic behind?

[kulasekhar]

there is no logic we want single row like ABC     ,aa

Thanks

Sekhar

[Anil_Babu_Samineni]

In fact, Report should need logic. Anyway, For your Question we can achieve like below

LOAD LEVEL1, LEVEL2, AutoNumber(Rowno(),LEVEL1) as ID;

LOAD * Inline [

LEVEL1 ,  LEVEL2

  ABC     ,aa

   ABC     ,dd

  ABC      ,mm

  DEF,  fg

  DEF,jf

  DEF,rt

  ];

In Pivot Dimension is -- LEVEL1

Expression is -- Only({<ID = {1}>}LEVEL2)

Output this?