How to display the field with 0 values in a table chart

[abc_18]

Hello,

I have a field called product, under that total 4 values are present in master table, i have to show the count in a table chart.

Ex:-

Product

A

B

C

D

• Now the child table, which i am using having only two values A and B present, but in table chart it should display all 4 products.

Like below:

A 10

B 12

C 0

D 0

How can I achieve this, please suggest.

Regards

[Prashant_Naik]

Hi,

you can use Applymap() function

Mappingtbl:

mapping load distinct

product, value

from table;

parenttable:

load,

product,

Applymap('Mappingtbl',product,0) as Value

from parent_table;

Regards,

Prashant

[abc_18]

Hi Prashant,

 I have to achieve this directly in table chart, can't use applymap functionality.

And value is nothing but a mesaure expression created in chart.

Any other way around?

Thanks