count of two columns

[#1]

Hi I have the following table and need to do a count of how many AA with AA in the two tables I have, how many AA, AA to B and so on

NO_PARTE	ABC VENTA	ABC UTOPE
6039863	AA	AA
TUET11395	AA	C
6041985	AA	AA
6041987	AA	AA
32010 F4060-1	AA	C
20850724	AA	C
TUET10400	AA	C
R235733	A	C
TUET6840	A	C
070GU107	A	C
101-464-3X	A	AA
84239389	A	C
4303913	A	B
4302265	A	C
TUET11012	A	AA
TUET11026	A	B
301767-14	A	C
TUET11011	A	AA
1285990C2	A	C
TCET4617	A	AA
TUET10790	B	AA
R108997	B	C
310693A1	B	AA
101-464-1X	B	AA
TUET7270	B	C
81862903	B	AA
TCET4618	B	AA
5-P-1004	B	C
360335A1	B	A
21937	C	AA
201-463-8	C	AA
TDFM1352	C	AA
313464	C	AA
TDET0880	C	C
54656	C	AA
4300297	C	B
301742-106	C	A
21216	C	AA
25-17-1-222X	C	C

for example

		UTOPE
		AA	A	B	C
VENTA	AA	2	1	-	3
	A	1	-	2	7
	B	5	1	-	3
	C	6	1	1	2

Thanks.

[swuehl]

Hi,

just create a pivot table chart with

=count(NO_PARTE)

as expression, maybe like attached?

Regards,

Stefan

[#3]

Hello.

Thanks for the reply, gave me an idea of ​​how to do it.

Only I have a problem my columns are an expression and do not leave a dimension as he could make.

I'll give the expressions.

ABC VENTA.

if(RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))>=.95,'C',
if(RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))>=0.80,'B',
if(RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))>=.50,'A',
if(RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))<=0.50,'AA'))))

ABC UTOPE.

if(sum({$<AGRUPADOR={'15_UTOPE'}>}DATA_AVER)/sum({$<AGRUPADOR={'01_VENTAS'}>}DATA_AVER)>=.10,'AA',
if(sum({$<AGRUPADOR={'15_UTOPE'}>}DATA_AVER)/sum({$<AGRUPADOR={'01_VENTAS'}>}DATA_AVER)>=.07,'A',
if(sum({$<AGRUPADOR={'15_UTOPE'}>}DATA_AVER)/sum({$<AGRUPADOR={'01_VENTAS'}>}DATA_AVER)>=.0,'B',
if(sum({$<AGRUPADOR={'15_UTOPE'}>}DATA_AVER)/sum({$<AGRUPADOR={'01_VENTAS'}>}DATA_AVER)<.0,'C'
))))

Regards.

[swuehl]

Hector,

maybe you could use two calculated dimensions using above two expressions in an advanced aggregation with dimension NO_PARTE.

Something like

aggr( YOUREXPRESSIONS, NO_PARTE)

Could you upload a small sample app here to the forum?