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

[simenkg]

On the presentation tab: Uncheck "Supress Zero-values".

See if that fixes it.

[jagan]

HI,

Try like this

Chart Properties -> Presentation -> Uncheck Suppress Zero-Values option.

Hope this helps you.

Regards,

jagan.

[kaushiknsolanki]

HI,

In presentation tab Deselect "Suppress Zero"

Regards,

Kaushik Solanki

[Anonymous]

No, The issue comes when I do a selection and the "associated" values are less.

Take a look at the example and see that when we select the product "AWC Logo Cap" the list of Customers in the table data goes from 3 to 1 (I need to show the 3):

Regards,

Javier

[simenkg]

See the attached file.

I Created a new expression as sum({$<Product=>}1) and then under presentation you select the column and check Hide Column.

[Anonymous]

Yes. You are right.

The point here is that the g imagine that I have one hundred of different attributes (product, product type, country, ...). And the table does not only shows customers, with a Group you can select any of them and the behavior should be as I explained... independently of the selection and the attribute shown in the table.

Thanks

Javier

[simenkg]

Use the expression:

sum({1<Customer=$::Customer>}1)

instead.

[#9]

Then use this expression for the hidden column:

sum({1<Customer=p(Customer)>}1)

See attach.

[Anonymous]

Hello,

Ok. I understood what you mean. The tricky thing is that I need to present the data in a matrix, with Customer x Product. Like in the example attached.

Regards,

Javier