Can you fix the headers in a pivot table

Options

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

Best Answer

  • david_cunningham
    Answer ✓
    Options

    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

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Answers

  • david_cunningham
    Answer ✓
    Options

    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

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**