Hi All,
I have got a webi document in this fashion
Tier Household Count Revenue
Greater than 1M 48 3548454
500k-1M 25 464354
Less than 500K 29 175533
The above field Household Count is nothing but Count([Household Id]), i.e. we have 48 household's whose value is greater than 1M.
Now I have another document , document 2 with household id related data, my question is how do I link them respectively. For example if I click on 48 it should give related data to those 48 household's. Please help me out.