How to merge two different tables to one

[raju_salmon]

Hi Experts,

Please help me on the below.

I have two tables

1) Dimension: Continent

    Expression: Sum(Sales)

2) Dimensions: Country

    Expression: Sum(Cost)

I want to produce single table with 1 Dimension and 1 expression. Where dimension should list Continent, Country values with respective to the relevant expression.

Thank you in advance.

Regards,

Raju

[swuehl]

You want to list Continent and Countries in the same dimension of a chart and then show sales and costs in the same expression column? Wouldn't this be quite confusing?

Maybe I don't understand what you are after. Some sample lines of data and your expected result might help.

[raju_salmon]

I have got a solution in https://community.qlik.com/thread/214540

Example:

Dimension:

=pick(match($Field,'Year','Month') ,Year,Month)

Expression:

=Pick(Match($Field,'Year','Month'),

Sum(Sales),

Sum(Cost))

But however i need to show Total for each dimension. Like we show in pivot table. Any suggestion on this?

[raju_salmon]

[shreya_nadkarni]

[shreya_nadkarni]

Concatenate Two table to get the Total.