I'm not sure I completely understand, but if you are wanting to filter by company without affecting the results in your view, this method may be useful to you:
thanks for quick answer. Please look at the screenshots, maybe they desbribe my problem better than I did it. In Screen_1 are all Companies selected. And so I easily get the right Grand Total for the complete operating figure (red marked). But usually I selected only fewer Companies (screen 2) for better view and compare. But in this selection I still want to know how is the total sum or total average from all companies in this year and measure.
Is there anybody out there? I really need help for my request.
As Matthew suggested table calculations should work in this situation.
If you can upload some sample data in excel I can create a mock up workbook for you
thanks for Example. But I can't open it on tableau public. error: "The requestes workbook does not exist on Tableau Public. Only workbooks that are currently available on Tableau Public may be opened".
Do you know how I can open it?
Ok, I will try to explain the steps based on the image you have attached in the previous post.
1.Click on Dimensions right corner drop down and select Create Calculated Field
2.In the formula area please put Lookup(Attr([Lebensversicherer]),0) then give a name to the calculation and save.
3.Now remove the existing "Lebensversicherer" filter and place the newly created calculation into filter.
hope this will help ..