Display pivot table data in grid portlet

[Monica_Rampradeep_Raj]

I want to create a grid portlet which should display a pivot table data. Is there a way to do it?

 

Thanks in advance.

[David Morton]

We can create portlets based on NSQL queries, so as long as you can build the SQL to deliver the data then yes, easily.

 

Perhaps you need to explain your requirements a little more to get a more meaningful answer though.

[Monica_Rampradeep_Raj]

Yeah, sure. Let me brief it. I'm trying to build a custom portlet which displays values in time sliced manner. The query output looks like

 

A - Jan 17 - $X

A - Feb 17 - $Y

 

Now in the portlet, I want this to be displayed as

 

              Jan-17            Feb -17

A            $x                     $Y

 

Is there a way to get this done with portlet?

[David Morton]

Yes ; you need 2 "dimensions" in the NSQL. At the moment it looks like you have a single dimension that returns "A - Jan17", "A - Feb 17". If you make it two dimensions with the first dimensions being "A" and the second dimension being "Jan 17", "Feb 17" then you will be able to display as a grid (with a variable number of columns depending upon the data that the query returns).

 

Multi-dimensioned portlet/query is what you should research.

[Monica_Rampradeep_Raj]

Thank you Dave_3.0, that helped!