is there a way to show both the Min and Max in the same cell on a pivot table?
I have placed both in the data field but it shows two pivot tables, one for each… it would help if I could get both in 1 cell…
From an example like this is the data and the pivot table.
You can do it with conditional formatting.
Condition 1 for the cell:
Condition 2 for the cell:
Sorry for the German-UI.
It has min and max, use concatenate in a third cell, then make the PivotTable.