Related question… I have a dashboard powered by pivot tables which I want to sent to my team in Germany.

Could you tell me what the equivalents of “(All)” and “(Multiple Items)” are in a Pivot Table in German Excel?

The reason for this is that I have “if” statements which convert “(All)” from the pivot table to “total” in the dashboard and “(Multiple Items)” to “Selected sites”. I plan to use “=IF(OR(…” to include the German alternatives.

(I also need the French and Italian equivalents if any one can help?!)