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 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.
