Ask Your Question

Pivot table data field show min and max

asked 2019-08-28 19:19:38 +0200

clos911 gravatar image

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..

edit retag flag offensive close merge delete


From an example like this is the data and the pivot table.

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2019-08-28 21:40:06 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-08-29 15:57:20 +0200

It has min and max, use concatenate in a third cell, then make the PivotTable.

edit flag offensive delete link more

answered 2019-08-29 09:54:14 +0200

ebot gravatar image

updated 2019-08-29 10:57:26 +0200

You can do it with conditional formatting.

image description

Condition 1 for the cell:

image description

Condition 2 for the cell:

image description

Sorry for the German-UI.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-28 19:19:38 +0200

Seen: 40 times

Last updated: Aug 29