Forum Discussion

UrokoSaki's avatar
UrokoSaki
Copper Contributor
Sep 27, 2023

Need help with ROLLUP

Hello every one,

i have a really hard time i need to create Table that look like this:

i manage to do all the fields besides the grand total for each year,

this is my syntax:

i try a lot of syntax with a ROLLUP, and every time its make a mess with the data.

 

 

 

1 Reply

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    That's really to less on information and no one can query screenshots, so they are useless.
    Please post table design as DDL, some sample data as DML statement and the expected result.

Resources