Matrix change to show all values. Why?

[gomezc73]

Hi experts,

    I have a problem because in my report I have two matrix that shows amounts, the first matrix has a summary and the other matrix show the detail by accounts.

   When I select 1 row in the first matrix I need to show the details in the second matrix. that works perfectly.

      

  The issue is when I select one account in the second matrix, immediately it loses the filter of the first matrix and shows all accounts, (I tried changing the iteration to NONE but nothing happen)

  I need that the information in the first and second matrix remains unchanged because I am showing totals in some Cards and in a hidden panel the details of each account.

  Can you please help me?

  This is how the tables are related:

    

These are the tables I am using:

Summary:

Expense Category	Type	Amount
01- Restaurant Crew	a) Crew Payroll	690465.65
01- Restaurant Crew	b) Crew Benefits	16048.89
01- Restaurant Crew	c) Crew Medical and Claims	70853.95
01- Restaurant Crew	d) CAM Expenses	113393.78
01- Restaurant Crew	e) Other Crew Expenses	6326.14
02- Fuel Expense	a) Fuel Expense	2255029.44
03- Kitchen expenses	a) Fixed Docking & Other	120603.82
03- Kitchen expenses	b) Maintenance	398165.33
03- Kitchen expenses	c) Utilities & Other	5839.65
04- Maint.,Consumables, & Dryd	a) Consumables	133957.26
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	403296.7
04- Maint.,Consumables, & Dryd	c) Docking Expenses	47599.22
04- Maint.,Consumables, & Dryd	e) Damage Expense	0
05- Other Restaurant	a) Telephone Expense	7369.09
05- Other Restaurant	b) Freight	37211.33
05- Other Restaurant	c) Miscellaneous	101057.45

details:

Expense Category	Type	Restaurant	OBJ_DESCRIPTION	AccountNbr	DESCRIPTION	Amount
03- Kitchen expenses	b) Stevedoring	Miami	Travel	XXXX00061131019	Nassau, Bahamas	500
03- Kitchen expenses	b) Stevedoring	Miami	Travel	XXXX00061131044	Port Canaveral	-563.65
03- Kitchen expenses	b) Stevedoring	Miami	Travel	XXXX00061131068	Bayonne, NJ	398228.98
02- Fuel Expense	a) Fuel Expense	Miami	Bunker Swaps	YYY6123	Bunker Swaps	-421702.48
02- Fuel Expense	a) Fuel Expense	Miami	Bunkering	XXXX00061211100	Bunker - IFO	2394579.4
02- Fuel Expense	a) Fuel Expense	Miami	Bunkering	XXXX00061211200	Bunker - MGO	219696.29
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Cleaning Supplies	3334017201	Cleaning Supplies	73.5
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Cleaning Supplies	3334027201	Cleaning Supplies	343.7
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Cleaning Supplies	3334107201	Cleaning Supplies	197.66
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Consumable Stores	XXXX40162033930	Office Materials Crunchtime	642.46
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Consumable Stores	XXXX40262033000	Nautical Stores	4008.63
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Consumable Stores	XXXX40262033300	Pollution ctrl/pers sfty Eq	12061.32
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Consumable Stores	XXXX40262033400	Tools & Instruments	9559.13
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Consumable Stores	XXXX40262033600	Painting Equipment	6298.5
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Consumable Stores	XXXX40262033700	Cleaning Material & Equip.	5510
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Consumable Stores	XXXX40262033800	Lube Oil & Lubricants	42704.18
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Consumable Stores	XXXX40262033810	Chemical Additives	10332.95
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Consumable Stores	XXXX40262033910	Welding Materials	17611.05
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Consumable Stores	XXXX40262033960	Pipe & Pipe Fittings	11968.55
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	Consumable Stores	XXXX40262033970	Steel,Metals and Fasteners	11316.24
04- Maint.,Consumables, & Dryd	c) Docking Expenses	Miami	Docking Expenses	XXXX40262055009	DD Amortization	47599.22
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40262044118	PAX Freight/Service Elev.	1014.79
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40262044153	Refrgs, Walkin boxes& Ice Mach	6257.71
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40262044180	Office and Engraving Equipment	348.09
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40262044200	Lifting and Transport	1032.43
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40262044310	FW Generators incl Pumps	24357.71
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40262044320	Steer. Gear,Thrusters &Stabil.	955.79
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40262044330	Sewage, Garb. Hndlg & Inciner.	12967.32
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40262044350	Air Conditioning Equipment	1758.94
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40262044890	Common electric spares	3839.2
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40262044930	Common Engine Spares	2196.48
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40262044935	Common Refrg. Spares	7153
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40662044100	Laundry Equipment	14413.38
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40662044101	Galley Equipment	13450.37
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40662044102	Dishwashers	9430.34
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40662044103	Sanitary Equipment	4627.45
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40662044104	Water Features and Attractions	1905.69
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40662044105	Lighting	13403.47
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40662044106	Hotel Maintenance Misc.	25994.69
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40662044107	Flooring	4245.4
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40662044110	Furniture and Fixtures	8154.1
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40662044112	Refurbishment Misc.	6297.34
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40962044000	Hull & Superstructure	737.5
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40962044400	Comm  & Navig  Equipment	4398.16
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40962044455	Closed circuit TV surveillance	10990.04
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40962044500	Engines	14046.84
04- Maint.,Consumables, & Dryd	b) Spare Parts-R&M/Refurbishme	Miami	Engines	XXXX40962044580	Reduct.  Gear Shafts&Prop	24658.06
05- Other Restaurant	a) Telephone Expense	Miami	Freight In	XXXX40262099000	Telephone Expense	7369.09
05- Other Restaurant	b) Freight	Miami	Freight In	XXXX40262099200	Freight In	25243.52
05- Other Restaurant	b) Freight	Miami	Freight In	XXXX40262099202	Destination Fees	73.85
05- Other Restaurant	b) Freight	Miami	Freight In	XXXX40262099203	Air Freight/Special Transp.	1371.05
05- Other Restaurant	b) Freight	Miami	Freight In	XXXX40262099204	Freight -Landed Goods Advise	1444.8
05- Other Restaurant	b) Freight	Miami	Freight In	XXXX40662099290	Misc. Freight Expense	9078.11
05- Other Restaurant	c) Miscellaneous	Miami	Freight In	XXXX40262099921	Det Norske Veritas	29503.78
05- Other Restaurant	c) Miscellaneous	Miami	Freight In	XXXX40262099930	Waste Related Taxes	1641.55
05- Other Restaurant	c) Miscellaneous	Miami	Freight In	XXXX40262099990	Miscellaneous	-949.22
05- Other Restaurant	c) Miscellaneous	Miami	Freight In	XXXX40262099991	Hazardous & Other Reg. Waste	36246.13
05- Other Restaurant	c) Miscellaneous	Miami	Freight In	XXXX40262099994	Bilge Water	4410
05- Other Restaurant	c) Miscellaneous	Miami	Freight In	XXXX40262099995	Sludge Removal	29281.53
05- Other Restaurant	c) Miscellaneous	Miami	Freight In	XXXX40262099997	Grey Water Removal	923.68
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	General Supplies	3334017203	General Supplies	200.58
04- Maint.,Consumables, & Dryd	a) Consumables	Miami	General Supplies	3334027203	General Supplies	33.29
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Harbor Maintenance Tax	YYY6115	Harbor Maintenance Tax	5822.24
02- Fuel Expense	a) Fuel Expense	Miami	Misc Fuel	XXXX00061221000	Fuel Additives	62456.23
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Norfolk, VA	XXXX00061111002	Labadee	1324.98
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Norfolk, VA	XXXX00061111008	St Maarten	23136.39
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Norfolk, VA	XXXX00061111009	Antigua	6236.04
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Norfolk, VA	XXXX00061111012	St Kitts	2833.33
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Norfolk, VA	XXXX00061111019	Nassau	7626.5
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Norfolk, VA	XXXX00061111023	St Lucia	3252.77
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Norfolk, VA	XXXX00061111044	Port Canaveral	59330.89
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Norfolk, VA	XXXX00061111068	Bayonne, NJ	98919.94
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Norfolk, VA	XXXX00061111177	Perfect Day at Cococay, Bahama	336.64
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Norfolk, VA	XXXX00061111264	Glasgow (Greenock), Scotland	-309.28
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Norfolk, VA	XXXX00061111270	Southampton, England	-59514.79
03- Kitchen expenses	a) Fixed Docking & Other	Miami	Norfolk, VA	XXXX00061111294	Belfast, Ireland	-28391.83
03- Kitchen expenses	c) Utilities & Other	Miami	Other Kitchen expenses	YYY6132	Other Kitchen expenses	5839.65

[amitchandak · Accepted solution]

@gomezc73 , When you click on the second it usually cleans up filter and apply its own filter. The slicer can retain value, visual do not.

But Try CTRL+click and check

[gomezc73]

Hi worked perfectly using Control+Click, thank you.

PBI doesn't have a trick to allow this using only Click?