Column wise Quantity of all product

[#1]

Dear All,

I am attaching three screenshots .

I am having  data like screenshot 1 and 2 and my manager wanted to implement as it was in previous reporting tool ( which is screenshot 3)

Any how , i can show data column wise , but in that case i can not select /deselct product_type in run time.

Please suggest me what to do .

Any help/suggestion will be appreciated.

Regards

Pramod Kumar

[swuehl · Accepted solution]

Have you tried dragging the product_type dimension with your mouse to the top of your pivot table?  I think this should result in a table like requested.

Or maybe I haven't understood you request.

[#3]

Thanks Swuehi

It helps me lot .

Regards

Pramod Kumar