Skip to Content
0
May 04, 2018 at 12:40 PM

Merging two crosstabs in Lumira 2.0 Designer

1127 Views

Hi Experts,

I have a requirement where I have to merge two tables into one.

Both the tables have same fields as you can see. Only difference is the filter.

Left table is showing data for the selected Period(Listbox) while the right table is displaying data for " less than or equal to" the selected Period.

The User wants to merge both datasets into one as shown in second image.

I did this by setting '0' column width to zero in Right Table.But this is not the right way as when I apply some of the global filters then number of records in both the table gets different and then this trick fails.

Is there any way to achieve this??

Attachments

merge.png (68.7 kB)
merge2.png (79.7 kB)