From: | Steve Midgley <science(at)misuse(dot)org> |
---|---|
To: | Majid Khan <mk(dot)swati(at)gmail(dot)com> |
Cc: | postgres list <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: crosstab category mix |
Date: | 2017-06-12 13:46:51 |
Message-ID: | CAJexoSKHupKeUK1UFwOkgHUi_NYEmRax_6+L6EbRj_jmvr2p5Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Jun 12, 2017 12:53 AM, "Majid Khan" <mk(dot)swati(at)gmail(dot)com> wrote:
Hi,
favorite
<https://stackoverflow.com/questions/44487568/postgres-cross-tabs-mixes-categories-in-result-set#>
I have a query returning me three columns 'Date', 'District' and 'Total'.
There are four districts but some time a district may not have record for
corresponding date. I want to put all my districts in column and their
total in rows as ..
Date, District1, District2, District3, District4
While in my rows will be date along with the total value per district.
I am using crosstab to get the desired results. But in the result total for
one district is listed in other district though the datewise grand total is
same.
I don't know why crosstab query mixes categories. Please help.
Regards,
Majid
Please provide sample data and sql to allow us to see where your problem
is.
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Majid Khan | 2017-06-16 12:35:40 | Fwd: Re: crosstab category mix |
Previous Message | Majid Khan | 2017-06-12 07:53:34 | crosstab category mix |