Need help when select slicer in reports

[assemomar]

Hello

Could anyone please help me solve my problem, which is as follows:

When I select Factory Slicer, I need to show the correct Total Asset for each Factory
Example (as remarked in red box)
Factory : NEO-99 , ID Details : MIXER TRUCK-1 = 10
Factory : RAB-RM12 , ID Details : PUMP TRUCK-1 = 2
... etc

Thanks

[ryan_mayu]

where shoud the result come from?

could you pls clarify the calculation logic?

i only see 5 rows for Factory : NEO-99 , ID Details : MIXER TRUCK-1 

[Anand24]

@assemomar ,
Ideally what you are saying should happen automatically. Make sure through edit interactions that your Factory slicer is filtering ID Details slicer and Total ID Details card. Also, make sure ID Details slicer is filtering Total ID Details card.

[ryan_mayu]

could you pls provide some sample data and expected output?

[assemomar]

how can upload the original file to show you what i need , if you could show me better

[assemomar]

I upload the original file here

https://file.io/atQlnqQV1SvD