If you want see the day wise total that situation use running total function.
SEL NAME, MEASURE, DATE, SUM(MEASURE) OVER(PARTITION BY NAME ORDER BY DATE ASC ROWS UNBOUNDED PRECEDING) AS CUM_AMT FROM <<TABLE_NAME>> ORDER BY NAME, DATE ASC;
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!