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 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(AdminOppImportage DB!$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
https://docs.google.com/ spreadsheets/d/1jMHBl2xT4_ h3YFt1eoeoCfL-gninebQv_3- ApArzUAc/edit?usp=sharing
No comments:
Post a Comment