AnsweredAssumed Answered

Populate Grid - flip rows and columns

Question asked by schlot on Oct 19, 2015
Latest reply on Oct 27, 2015 by schlot

I have two years' worth of county based demographic statistics.

 

I have the same information for each year.  For example:  totalPopulation, PopulationOver18, Population17_44, Population45_64 etc

On a map click event for the  county layer, I've been asked to display it with years for the columns and rows for the population breakouts,  This format is my question. 

 

I typically use dGrid.  It seems like I can manipulate the data prior to populating it, but I can't quite wrap my brain around how to go about this.

 

Example:

COUNTY NAME

Statistic
Year 1
Year2
Total Population123145
Population Over 185666

 

I don't know if this is a true pivot table, or if this is just a 'turning data on it's head' sort of format.  

Outcomes