Hide last pivot column

[limon]

Hi everyone!

I am working on hiding the last pivot column from visualization. 

I’ve already explored these workarounds found here without any solution:

1. Add calculations to each column you want to show and hide original columns → using pivot_index() or pivot_where()
2. Customize column label adding empty character and white color for text.

None of them works for me, because I need to main the reference of the week in the column name, and as it changes dynamically must not be hardcoded (and I also want to avoid named them “actual week, actual week -1,…, actual week - n”)

I filtered data for the last 7 weeks to accurately calculate Change % for the last 6 weeks, but because I only have to show the performance of the last 6 weeks, I need to hide the last one (in the image above “2022-04-09”)

[Dawid]

This is actually a pretty good use case. Too bad we can’t limit the display of pivots like we have ability to do with rows.

To be honest, if not showing the latest pivot is CRUCIAL to your business, I would add a column with a LAG to your data model so that you don’t have to calculate the delta using last 6 weeks instead of 7