Ezi
Ezi

Reputation: 2210

Pivot Grid display data fields in row area

I got a request to change the devExpress pivot grid, so that it shows only one column per size, the values should be displayed as rows. Please see the images as its hard to explain in writing.

Current setup: enter image description here

Desired output (done in excel): enter image description here

Upvotes: 2

Views: 1750

Answers (1)

nempoBu4
nempoBu4

Reputation: 6621

You can use PivotGridOptionsDataField.Area property. If you set this value to PivotDataArea.RowArea then you get what you want: enter image description here

Upvotes: 3

Related Questions