Pivot table and Grand Total issues!!!

[#1]

Hello Everybody,

I used Pivot table to summary information with 2 separated tables.

The problem is I want to use another table to display a grand total value of 2 tables above.

Please advise me the best way to implement it.

Please take a look on attached picture to get more detail.

Thanks,

Tai.

[#2]

Hi,

Can you share sample data or Qlikview file?

It will help us understand what expressions you used and how it can be summarized.

[Anonymous]

The formula you want depends on the data structure and the forumlas in the existing charts. If you attach your .qvw file it will be easier to help you out