Pivot Table 2 Items in one cell

[davidhall80]

Hello All

I have a spreadsheet with 2 Pivot tables on it.
One shows the numbers of Phone Calls
The second shows the average length of those calls.


Is it possible to show both of these values in one Pivot table in the same cell?
I would want both these values separated by a hyphen.
Also, does Power BI do this?

The cell Values would look as such:
56 - 4:27

Thanks Everyone!

 

[James006]

Hello,

Not sure to fully understand your constraints ...

Why don't you just create your recap table with the concatenation ...?

 

[davidhall80]

James
Can you elaborate on that some more. Thanks