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
