Contains but not filtered

[ecabanas]

Hi I want to do the following:

I have a table with sales

Date               orderid    item

01/01/2013      1               A

01/01/2013       1               A

01/01/2013        2             B

01/01/2013        2             A

01/01/2013        3             C

I wanna know a table with the orders (full items not only the selected) with items A=

Date               orderid    item

01/01/2013      1               A

01/01/2013       1               A

01/01/2013        2             B

01/01/2013        2             A

How could I do? if I select the Item A, the item B did not appear!!!

Thank's

Eduard

[swuehl · Accepted solution]

Right, if you select item A, this will exclude item B by default.

So you need to use set analysis (please check also the help for more detail), which allows to analyze a different set, try a straight table chart with dimensions Date, orderid and item and as expression something like:

=count({<orderid =p(), item= >} item)

The bold part is the set analysis part, using a set modifier with implicite field value definition (i.e. p() function).

See also attached.

Stefan

[ecabanas]

BRILLANT!!!!! You are a Master 😉

thank's

[ecabanas]

Stefan,

I'm doing a pivot with that and it works perfectly, but did not add correctly the total, I  tryied several combinations with aggr, but it doesn't work, HELPPP! 😉

=Sum({<SALESID =p(),DES_SUB1= >} IMPORTBRUT+CTEFISICO+CAMPANA)

Eduard