Pivot table Pivoting

[#1]

Hi Experts,

Can a pivot table be arranged in the way I have depicted in the attached picture.

I have three dimension(as shown in red, in the picture)...Item Number, Product Number and Reason of Return.

Please suggest.

Thanks.

[#2]

Hello Bikash:

One possibility to solve your situation is that you can create an inline table like this:

load * inline [

Dimension_Table               , Reason to return (name of the fild in your table)

Product Number                ,Bad

Product Number                ,not working

Product Number                ,the list of the all possibilities

Item Number                     ,the list of the all possibilities

Bad                                   , Bad

not workling                         , not working

etc                                   , et

];

Then is your pivot table you will choose Dimension_Table as your dimmension and the expresión will be something like this: If(Dimension_Table = Prodcut Number, only(Product Number),

       If(Dimension_Table = ItemNumber, only(ItemNumber),

       count(Reason to return))

Of course that you instead of making an inline table you could do it in an automatic way by linstin the reasons.

I hope It will be useful for you.

Regards,

Marcelo