Pivot Table with Text

[Melissa Zinder]

Hi! Here is the spreadsheet I'm referring to: https://docs.google.com/spreadsheets/d/1VmlqVlh7OBj6hXL1C6Lpw2P5YDY9AdGzNGPqGQvMJi8/edit?usp=sharing

I'm trying to make a pivot table of sorts with text, using the data from the "Stories" tab. A template of the chart I'd like to make is on the "Articles by Magazine Date" tab. I'd like the headlines from the "Stories" tab that correspond with each "Magazine Date" to be listed under their appropriate "Magazine Placement" Category in the "Articles by Magazine Date" tab. Can someone help? I've been trying to create a query, but I can't get it to work.

[Daniel LaLiberte]

Hi Melissa,

Your question sounds more specific to Google Sheets queries, unless you are talking about how to query the data for an actual Google Charts chart.  (documented here: https://developers.google.com/chart/interactive/docs/spreadsheets)  You might get more help in a Google Sheets forum, in any event.  Try this:  https://groups.google.com/forum/#!forum/google-spreadsheets-api

On Mon, Jun 6, 2016 at 3:16 PM, Melissa Zinder <melissa...@gmail.com> wrote:

Hi! Here is the spreadsheet I'm referring to: https://docs.google.com/spreadsheets/d/1VmlqVlh7OBj6hXL1C6Lpw2P5YDY9AdGzNGPqGQvMJi8/edit?usp=sharing

I'm trying to make a pivot table of sorts with text, using the data from the "Stories" tab. A template of the chart I'd like to make is on the "Articles by Magazine Date" tab. I'd like the headlines from the "Stories" tab that correspond with each "Magazine Date" to be listed under their appropriate "Magazine Placement" Category in the "Articles by Magazine Date" tab. Can someone help? I've been trying to create a query, but I can't get it to work.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/dfa29058-ef54-44f8-af6e-66ea0526225e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Daniel LaLiberte

dlaliberte@Google.com   5CC, Cambridge MA