Merging two crosstabs in Lumira 2.0 Designer

[former_member559159]

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??

[TammyPowlas]

This is what worked in Design Studio - see https://answers.sap.com/questions/73579/merging-2-queries-into-single-crosstab.html but I am not sure if it will work in Lumira Designer.

Another idea is to blend back in Lumira Discovery and then bring it into Designer.

What is your data source?

[former_member559159]

Data Source/Data Flow is ----> Hana->Universe->Discovery->Designer

The problem here is that both the tables has same Measures, and I have to apply different filter conditions on them.