Cannot add calculated columns in a pivot table

Hi GON76 ,

Thanks for clarifying now it makes total sense what you’re trying to do. The reason those fields (Compliance Status and Learning Path Completion) “disappear” when you drop them into the Matrix is because the Matrix visual doesn’t work like Excel. Instead of just showing columns side-by-side, it turns them into a hierarchy under Columns, which is why you only see drill-down options instead of flat columns.

Since you just want those calculated fields to show up as normal columns, the easiest fix is.

• Use a Table visual instead of a Matrix.
• In the Table, every field you drag in (Username, Compliance Status, Learning Path Completion, etc.) will show up as a separate column exactly how you expect.

So,

• Table = flat columns (what you want here).
• Matrix = grouped/expandable view (good for summarizing, but not great for your use case).

If you switch the visual to Table, you’ll see those calculated columns right away with no drilling or extra steps.

You’re not doing anything wrong this is just how the Matrix is designed. For your scenario, the Table visual is the right one.

Regards,
Akhil.