@Jakub ,
I think you would have to use level aware calculations, have a look at our blog : Create advanced insights using level-aware calculations in Amazon QuickSight | AWS Business Intelligence Blog
Furthermore you can use arena to load the sample data and create an analysis , other community can help by providing correct calculations : QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community
Kind regards,
Koushik