Pivot / Crosstab With Count Unique data.
Date: Wed, 16 Jul 2008 22:55:25 -0700 (PDT)
Message-ID: <865cae5a-6c05-42b6-a471-7c976571ffea_at_y38g2000hsy.googlegroups.com>
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
The result of my pivot is That I want:
Could we create this kind of pivot?
If it could be done, how we do it?
Sub Area
Area SubAreaA SubAreaB Total
AreaA 3
3 3
AreaB 1
2 3
Total 3
2 3
Thanks in advanced Received on Thu Jul 17 2008 - 07:55:25 CEST