• Registered: 2017-05-15
  • Posts: 722

Topic: Crosstab Sample

Hello MVD

May I request a sample of a crosstab query to display in tablegrid. What i mean a rows to column display.

Thanks!

sample:

Category | Amount
BMW       | 1000
BMW       | 1000
KIA          | 500
ISUZU     | 500

The result should be like this.
================
BMW   |   KIA   | ISUZU
1000    |   500   | 500
1000    |            |

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Crosstab Sample

Hello.


Check out this sql query

SELECT
SUM(CASE Category WHEN 'BMW' THEN Amount ELSE 0 END) "BMW"
,SUM(CASE Category WHEN 'KIA' THEN Amount ELSE 0 END) "KIA"
,SUM(CASE Category WHEN 'ISUZU' THEN Amount ELSE 0 END) "ISUZU"
FROM TableName
Dmitry.
  • Registered: 2017-05-15
  • Posts: 722

Re: Crosstab Sample

Thank You DRiveSoft!