Double column header

[#1]

i want to achieve this type of formatting in my straight table.

                         Month               Year

Region     Sales     Profit     Sales     Profit

#####      #####     ####     ####      ####

#####      #####     ####     ####      ####

#####      #####     ####     ####      ####

#####      #####     ####     ####      ####

Total        $$$$      $$$$     $$$$      $$$$ 

Also I want to have a label called total under the first Column and its a dimension column..

any ideas?

[stephencredmond · Accepted solution]

Hi,

I would probably use a pivot table for this.

Regards,

Stephen