Pivot Grid Swap Columns and Row

Toad Data Point
1

Dear all,

When sending the query results to a pivot grid. I’m able to arrange the view like this:

Year
Product A
Product B
2013
3601
883
2012
3387
851
2011
3641
946
2010
3903
998
In order to use this data I would like the view to swap the rows and column’s. Unfortunately, Toad Data Point build’s the view like this:

2013
2012
2011
Product A
Product B
Product A
Product B
Product A
Grand Total
3601
883
3387
851
3641
Is there a way to list the fields Product A en Product B under each other on the left? I need to export the view like this to excel sheet in order to use it.

Hope someone can help me with this.

Regards,

Fayaz

2

Put the product names in the Row area.

forum.png

3

Hi Debbie,

when trying your solution, i get data in the row area. I've included a screenshot, with the results:

grid view.jpeg
grid view.jpeg706×229 29.3 KB

Is there a way to see the fliednames: LINNEN, UTILITIES in the row area and see their (sum) values in the data area?

4

No I don’t know how to do that. The pivot grid really wants three elements, column, row and data. You need a text column that represents the product. This should
go in the row area. Then the value columns can go in the data area.

Debbie

From: Fayaz [mailto:bounce-fayazkallan@toadworld.com]

Sent: Wednesday, July 31, 2013 6:56 AM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Pivot Grid Swap Columns and Row

RE: Pivot Grid Swap Columns and Row

Reply by Fayaz

Hi Debbie,

when trying your solution, i get data in the row area. I’ve included a screenshot, with the results:

Is there a way to see the fliednames: LINNEN, UTILITIES in the row area and see their (sum) values in the data area?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.

5

Hi Debbie,

Thank you for your answer. I will rebuild my query to have three elements.

6

Feel so fortunate to see this thread for I have a similar question on a pivot grid control, and the grid column things also made me crazy.