Thanks so much for your help, Olaf! That works. But how can I get the "Headlines" (Column B) to show up instead of the number "1"?
On Wed, Jun 8, 2016 at 3:25 PM, Olaf Stolle <[email protected]> wrote: > Hallo Mellissa, > ja das scheint daran zu liegen das du die zu gruppierende spalte nicht im > select haben darfst und eine berechnung durchführen musst > =QUERY(Stories!$A$1:$K$5, "select J,count(A) group by J pivot K") > > schau auf das Sheet7 > > lieben Gruß > Olaf > > 2016-06-08 20:55 GMT+02:00 Melissa Zinder <[email protected]>: > >> I tried this query string, but it's not working: >> >> =QUERY(Stories!1:1000, "select A,B,J,K group by J pivot K",1) >> >> Can someone tell me why? >> >> On Monday, June 6, 2016 at 3:36:44 PM UTC-4, Melissa Zinder 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 Spreadsheets API" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "Google Spreadsheets API" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/google-spreadsheets-api/JidGb8BN8AI/unsubscribe > . > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Melissa Zinder [email protected] (804) 513-6054 -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
