• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Two categories in Pivot table

M

MP

New Member
How can we put two categories in Pivot table? I want product name and part number with sale s amount.(Not only one of Product name and number)

I can see only one of two ( Product name and part number )are in one row with Sales amount in normal pivot table formatting.


is there any way?


Thanks

MP
 
MP


Firstly, Welcome to the Chandoo.org Forums


With the pivot table selected and the Field Chooser open

You drag the particular category to the Column, Row or Page areas and the PT will rearrange itself
 
Thanks Hui

but not getting yet


See below:-

I need three column as 1 st Row labels which is 6020 ( part number ) then second column as REVOLUTION RANGE 16W BAY LAPTOP TRO ( part name ) and third is amount column $ 4244.04


Row Labels Sum of Revenue

6020 4244.04

REVOLUTION RANGE 16W BAY LAPTOP TRO 4244.04


Thanks

MP
 
You must log in or register to reply here.
Back
Top