Pivot Table Dimensions to Expression

[settu_periasamy]

Hi Team,

Find the below screen shot.

Source Data
Ctype	From	To	Product	Rate	Rec_No
NETP	5/31/2008	12/31/2015	BRND29707	6.85	1234
NETP	5/31/2008	12/31/2015	BRND29707	6.85	1235

In the Source data, Ctype, from, to , product and rate fields having same data. but the Rec_No is different. I need to make the single row for the product, Rate and Rec_No should be in the row field(Pivot table).

Thanks

[alkesh_sharma · Accepted solution]

Hello,

Please find the attached .QVW for your reference.

[#3]

Hi Settu,

click and hold on the dimension and then drag this up to the pivot location

hope that helps

Joe

[#4]

Any tips for someone struggling to "drag up"? I continue to select the dimension but the blue arrow continues to point upwards instead of sideways no matter where I drag it.

Also is there any way to do this without the dragging feature? In properties maybe?

[settu_periasamy]

hi,

hope you aware, 'drag up' is possible in the pivot table only not straight table.

share the sample.

[#6]

No other way to do this I'm afraid. Select and hold the mouse button and you get the blue arrow, when you 'drag up' take your mouse first into the expression area (the red box) and then up into the expression labels(up the red arrow) and it should change to a sideways arrow for you.

You might need to keep dragging up beyond the labels and outside the chart. it can be a bit funny at times to register the movement.

hope that helps

Joe

[#7]

Gotcha. Thanks for the tip!