Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
just create a pivot table chart with
=count(NO_PARTE)
as expression, maybe like attached?
Regards,
Stefan
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.
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?