• Hi Eirikur,

    How do I get the result like below without using pivot? Thx.

    ------------------------------------

    Dept | A | B | C | D |

    ------------------------------------

    Total | 100 | 120 | 140 | 150 |

    ------------------------------------