topic Pivot table with filtered columns getting extra unknown column in App Development

Pivot table with filtered columns getting extra unknown column

andreicatalin — Mon, 08 Apr 2019 17:25:19 GMT

Hi there,

I am trying to put together a pivot that shows data (both nulls and values) per a few categories (delete headers below) across a few months.

In some months there is data - in some, there isn't. I want to be able to show both.

The pivot returns this odd column - highlighted with 0s and null values. Any Insight as to how to get rid of it & have a clean table showing months with 0 and months with values?

Re: Pivot table with filtered columns getting extra unknown column

NhanNguyen — Mon, 08 Apr 2019 17:30:14 GMT

So you want to convert 0 to Nulls or?

Re: Pivot table with filtered columns getting extra unknown column

andreicatalin — Mon, 08 Apr 2019 17:36:54 GMT

Thanks for getting back.

I want to essentially remove the column with a null header.

I have column titles all across (although I obscured them in the screenshot). I essentially want the following:

Column1 Column 2 Column 3

Jan 0 0 0

Feb 0 0 0

Mar 0 0 0

Apr 0 0 0

May 58.1 1.3 0.3

etc.