Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

  • RE: Query for LastYear same Month

    I think the problem is that you're effectively double grouping. Try the following:

    WITH SALES AS (

    SELECT

    period, kode_lang, namaprod,

    kode_comp, kode_type, kodesalur, company,

    SUM(sales) AS sales

    FROM

    nv..bi_data2015_v1

    GROUP BY

    period, kode_lang, namaprod,...

  • RE: Query for LastYear same Month

    select

    period, kode_lang, namaprod, kode_comp, kode_type,

    kodesalur, company,

    ...

  • RE: Query for LastYear same Month

    Have you tried running your query from your LEFT JOIN separately with a WHERE clause that just gets data for 201312 ?

    That might help determine if it's a query problem,...

Viewing 3 posts - 1 through 4 (of 4 total)