Pivot / Crosstab With Count Unique data.

Hi,

I'm trying to create pivot, my data are area, sub area, member code.
On Pivot/Crosstab data area i want to calculate how many member that
access in sub area, and how many member that access in area, where as
on the raw data it self my member has many record on each area and sub
area. My be this will make an sample

    * AreaA        SubAreaA    Member1
    * AreaA        SubAreaA    Member2
    * AreaA        SubAreaA    Member3
    * AreaA        SubAreaA    Member1
    * AreaA        SubAreaA    Member1
    * AreaA        SubAreaA    Member2
    * AreaA        SubAreaA    Member1
    * AreaA        SubAreaA    Member3
    * AreaA        SubAreaA    Member1
    * AreaA        SubAreaA    Member1
    * AreaA        SubAreaA    Member2
    * AreaA        SubAreaA    Member3
    * AreaA        SubAreaA    Member1
    * AreaA        SubAreaA    Member1
    * AreaA        SubAreaA    Member2
    * AreaA        SubAreaA    Member1
    * AreaA        SubAreaB    Member3
    * AreaA        SubAreaB    Member1
    * AreaA        SubAreaB    Member1
    * AreaA        SubAreaB    Member2
    * AreaA        SubAreaB    Member3
    * AreaA        SubAreaB    Member1
    * AreaB        SubAreaA    Member1
    * AreaB        SubAreaB    Member2
    * AreaB        SubAreaA    Member1
    * AreaB        SubAreaB    Member3
    * AreaB        SubAreaA    Member1

The result of my pivot is That I want:

                     Sub Area

             Area                 SubAreaA    SubAreaB      Total

             AreaA                             3
3            3

             AreaB                             1
2            3

                              Total              3
2             3

Could we create this kind of pivot?

If it could be done, how we do it?

Thanks in advanced