Request help on dynamic table creation

[Anonymous]

hi all,

I am trying to create an dynamic table using 3 small source tables taken as example.But somehow it doesnt work. Can some one please look into the test file attached and guide me on this?

I have 3 tables PMM,RMM,CMM and when I try to select fields from these corresponding list boxes, a dynamic chart should be displayed.

regards,

Sahana

[sunny_talwar]

The attached sample is empty. Can you repost the document with data in it

[Anonymous]

Hi Sunny,

Apologies!!

I have attached the correct file.

I have 3 list boxes PMM,RMM,CMM. When I select fields from these , simultaneously a straight table needs to generate.Please can you help?

regards,

Sahana

[sunny_talwar · Accepted solution]

SubStringCount() function is case sensitive (unlike Like)

You need to try these conditions for your expressions

gst amt -> =SubStringCount(Concat(DISTINCT _RMM,','),'GST AMOUNT') = 1

amt payable -> =SubStringCount(Concat(_RMM,','), 'AMOUNT PAYABLE')>=1