Pivot Grid Rows

[gwilburn]

I have created a pivot grid that yields the aggregate data our users require. However, I'd like to have more than one static value on the row. What I mean is to have extra columns that the data is already grouped by.

Basically I have 3 additional data points in my data source that needs to be displayed along with the "Company Name". But I do not want to create extra/expandable rows by adding them to the "Left Axis". See where the red arrows are located below

Curious if there is a way to do this without combining them in my data source?

RF Pivot Grid.png

[sean.lanktree]

No, you would need to create a new column in your data source for this.

[gwilburn]

OK... I've been working on that, but it's very difficult to accomplish when the values are numeric. You kind of want them in a column so they can be right justified (and line up visually).

FWIW, I wouldn't have to fool with this if DB2 SQL just had a pivot function :rolleyes: