Tuesday, June 20, 2017

yogi_Query Data Grouping By Month Names

Google Spreadsheet   Post  #2188
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-20-2017
question by Pashenkov:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/WpBZQU1j5ko;context-place=forum/docs
QUERY WITH DATE LOST FORMAT
Hello everyone,  I need help with a query which I want to show sum values and group by month,  here is what I got Until now
=QUERY(query(AdminOppImportageDB!$A$1:Q;"select J, sum(H),sum(I),sum(H)*I where (K <> 'Perdida' and Q=1) group by J,I ");"select Col1, sum(Col4) where Col2 is not null group by Col1 label Col1 'Valor de Oportunidades',sum(Col4) ' '")

but is seems to be incomplete due to there are months repeated at the result,

please help me out with this,

thanks