Negative Time in Pivot has no legend and no Vertical Value

[mharald]

Hello,

Have this pivot chart which has a few time values for 2017 and 2018. One for each month. Negative time Values are being shown correctly in the RAW Data:

[TABLE="width: 308"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mrz[/TD]
[TD="align: right"]12:36[/TD]
[/TR]
[TR]
[TD]Apr[/TD]
[TD="align: right"]22:39[/TD]
[/TR]
[TR]
[TD]Mai[/TD]
[TD="align: right"]07:11[/TD]
[/TR]
[TR]
[TD]Jun[/TD]
[TD="align: right"]04:04[/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD="align: right"]38:47[/TD]
[/TR]
[TR]
[TD]Aug[/TD]
[TD="align: right"]38:34[/TD]
[/TR]
[TR]
[TD]Sep[/TD]
[TD="align: right"]11:00[/TD]
[/TR]
[TR]
[TD]Okt[/TD]
[TD="align: right"]15:21[/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD="align: right"]12:18[/TD]
[/TR]
[TR]
[TD]Dez[/TD]
[TD="align: right"]05:58[/TD]
[/TR]
[TR]
[TD]2018[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD="align: right"]14:17[/TD]
[/TR]
[TR]
[TD]Feb[/TD]
[TD="align: right"]35:55[/TD]
[/TR]
[TR]
[TD]Mrz[/TD]
[TD="align: right"]33:33[/TD]
[/TR]
[TR]
[TD]Apr[/TD]
[TD="align: right"]06:15[/TD]
[/TR]
[TR]
[TD]Mai[/TD]
[TD="align: right"]02:26[/TD]
[/TR]
[TR]
[TD]Jun[/TD]
[TD="align: right"]33:57[/TD]
[/TR]
[TR]
[TD]Jul[/TD]
[TD="align: right"]02:08[/TD]
[/TR]
[TR]
[TD]Aug[/TD]
[TD="align: right"]-23:43[/TD]
[/TR]
[TR]
[TD]Sep[/TD]
[TD="align: right"]-00:26[/TD]
[/TR]
[TR]
[TD]Okt[/TD]
[TD="align: right"]13:31[/TD]
[/TR]
[TR]
[TD]Nov[/TD]
[TD="align: right"]01:17[/TD]
[/TR]
[TR]
[TD]Dez[/TD]
[TD="align: right"]00:00[/TD]
[/TR]
[TR]
[TD]Gesamtergebnis[/TD]
[TD="align: right"]287:38


[/TD]
[/TR]
</tbody>[/TABLE]
But the pivot doesn´t show the negative values:

 

[mharald]

i'd show you the pivot table but I cannot add attachments, nor can I edit my post (?). Anyway, I'd love to see those negative values on my Pivot. Any ideas please?

Thank you and regards,

Harald