How to show only (and only) the selected values even if all expressions are 0

[Anonymous]

Hello everybody,

  We have a request in an existing project and we are not finding the right way to implement it:

  We need to create a graphic type table that show all the selected values of a given attribute even if all the KPIs are 0.

  For example, if we select this:

  We get this report:

DESC_ACTIVIDAD_RELACI	ENTORNO	ACTIVEBUSINESS	MARKETBASE	Total
ABANICOS MIN - 1882		11	1	12
ABOGADOS - 2707		1.072	508	1.580
ABONO QUIMICO FAB - 2050		0	1	1
Total		1.083	510	1.593

  When we modify the selection:

  We get a diferent report (of course):

DESC_ACTIVIDAD_RELACI	ENTORNO	ACTIVEBUSINESS	MARKETBASE	Total
ABANICOS MIN - 1882		6	0	6
ABOGADOS - 2707		43	15	58
Total		49	15	64

  We need that the row “ABONO QUIMICO FAB – 2050” appears also.

DESC_ACTIVIDAD_RELACI	ENTORNO	ACTIVEBUSINESS	MARKETBASE	Total
ABANICOS MIN - 1882		11	1	12
ABOGADOS - 2707		1.072	508	1.580
ABONO QUIMICO FAB - 2050		0	0	0
Total		1.083	510	1.592

  The issue here is that if we mark “show all values” it shows all the values of the attribute “DESC_ACTIVIDAD_RELACI” wich are more than 600 hundred. We only want to show those that are selected even if there is no data related.

  Simple but we are blocked… any clue??

Many thanks

[jagan]

Hi Javier,

Try this expression

=Sum({1<Customer=p(Customer)>}Quantity)

Regards,

Jagan.