Forum Discussion

roasty1980's avatar
roasty1980
Frequent Visitor
6 years ago
Solved

Summary table based off another table

Hi all   I have a table that has the months Jan to Dec as fields containing a number.  I would like to sum those month fields into a new table.  The new table would have 2 fields...   Month |  No...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi roasty1980 ,

     

    Follow steps in order in Query Editor:

     

    Sample data considered:

     Then select all the 3 columns as unpivit them:

     

    You will end up with following:

     

    Now select your ATTRIBUTE column and then GROUP BY:

    A window appears, then provide following information:

     

    You end up with the required output:

     

    Hope this helps.

     

    Thanks,

    Pragati