How to make filter pane static for a field?

[Anonymous]

I have two tables Tab A and Tab B.

Tab A:

Load

Version,

Business,

Type,

ID

from Highest

Tab B:

Load

Bu as Business,

Li as Type,

Purchase

from Purchase

So Tab A and B has Business and Type field common. But Tab B has more records in the field Business and Type.

I have created a visualization

Business	Type	Sum(Purchased)	Count(ID)

I have a filter pane to Select Version, because I want to select different Version for Count(ID) field, but I want to keep Sum(Purchase) static (it should not change with selection of Version).

But the problem is when I select Version from the filter pane, only matching rows from both the tables are showing up. Some records which are not there in Tab A are getting dropped.

I want only Count(ID) field should change on selecting Version and Sum(Purchase) should remain constant.

Please help experts. I will really appreciate any suggestion.

Thanks!

[settu_periasamy]

maybe try like

Sum({1}Purchase)

[Digvijay_Singh]

May be -

Sum({<Version=>}Purchase)

[Anonymous]

It worked . Thank you so much.