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 Received on Thu Jul 17 2008 - 00:55:25 CDT