This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
If you like, you can do thisWITH temp AS ( SELECT DISTINCT ColumnA,
SUM(ColumnC) AS result FROM example GROUP BY ColumnA ), fact AS ( SELECT
ex.*, ROW_NUMBER() OVER (PARTITION BY ColumnA ORDER BY ColumnA) AS rn,
FROM example ex SELECT fact.ColumnA, f...
Hi,I can only think of this solution. Hope it helps.view: example2 {
derived_table: { sql: select ColumnA, ColumnB, ColumnC, sum(ColumnC)
OVER (PARTITION BY ColumnA) AS result from example ;; } dimension:
ColumnA {} dimension: ColumnB {} dimension: C...