Can you fix the headers in a pivot table

Kyle_Russell

Hi All,

I have a pivot table in my dashboard showing a last 12 month trend in the columns and a list on people in the y column - the issue I'm having is if I filter for a specific person then the columns with no data disappear i.e. if there is only quarterly data my picot will only show 4 columns. Ideally I want to fix the 12 columns so it despite there being no data in 8 of them.

Does anyone know if this is possible?

Thanks

david_cunningham

In order to achieve this you would need to have those rows available in your dataset.

What I mean by this is | month1: 100, month2: 0, month3: 75

Rather than | month1: 100, month3: 75

You'll want to use a date dimension table and joining up in your ETL.

david_cunningham

In order to achieve this you would need to have those rows available in your dataset.

What I mean by this is | month1: 100, month2: 0, month3: 75

Rather than | month1: 100, month3: 75

You'll want to use a date dimension table and joining up in your ETL.