3 Replies Latest reply: Nov 1, 2011 8:10 PM by Stefan Wühl

count of two columns

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.

• Re: count of two columns

Hi,

just create a pivot table chart with

=count(NO_PARTE)

as expression, maybe like attached?

Regards,

Stefan

• count of two columns

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.

ABC UTOPE.

))))

Regards.

• Re: count of two columns

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?