This might make a bit more sense with semi real data to explain.
The payment types are all joined from three different SQL tables in to one to produce the Payment Type column. These three SQL tables are also bought in to the app separately to retain the differentiation between Benefit (1)/Income(2)/Other(3).
The mockup below is what I am hoping to achieve (the ////// sections are "filtered out"):
This keeps all records visible for contact 37634 - RA, CES, DSP, PNSUP, Cash/Investment/Savings/Managed Investments and for contact 221121 - RA, CES, DSP, PNSUP, Cash/Investment/Savings as they both contain both selections from LB 1 & 2 and the rest get filtered out as they only contain no or only 1 of the selections.
I am guess I am going to need to do some kind of filtering at [GT Code] level, not [Payment Type] level to retain the extra payment types, but I am completely lost as to how to achieve this.
Thanks again for taking the time to look at this.
List box 1,2,&3 are coming from same table? and if coming from same table then because of data association it will select the associated data.
But while going though your file i'm not able to select 1 & 2 or 3 dimension at the same time means data model or data is not correctly mapped/ there is no associated data . Please check the data model.
If you select any field it will filter out on that field with all associated values so it is not possible to show other details also with selected result.
If i am not misunderstood you might require this for doing comparative analysis? If yes then For this type of thing you can create one more chart with alternate state which will not change on any selection.
Your data (LB 1, 2, 3...) is not having any connectivity. It doesn't mean that the data model is not good. I can see there is no connectivity in data point of view i.e. May be wrong mapping.
Add 1,2,3 into your pivot and have a look at it, then you can understand your data.
Prashanth Reddy D.