Is there a way to hide the first column in a table that is calculating the month-over-month difference?
Hi @stormsarah,
In this reference, I presume you are utilizing a calculated field to get the month over month data? If that would be the case, the MoM calculation is relying on the prior month’s data to pull in it’s value. Therefore, you’ll always need to contain that first month so that your calculation has something to base it’s month over month off of.
So unfortunately, even with work arounds, this may be difficult to achieve because if you setup any type of parameter to remove that first month, you’ll be unable to get the MoM for the next month as it will have nothing to base off of.
While this will not create the ultimate outcome that we are looking for, my best suggestion for this instance, would be to manually shrink that column by clicking on the right border and dragging left.
Hey @Brett, just to confirm, there is absolutely no way to hide the first column in a MoM calculation without removing that date reference from the calculation?
Hi @stormsarah,
A calculation that is based on prior month’s data (like a MoM), will need that prior month to be included so that it can utilize it’s data. Otherwise, removing that first month, Dec. 2023 in this instance, will then just empty the Jan 2024 data as it will no longer have the prior month to compare to.
As pivot tables do not allow you to hide individual columns, that is currently the case.
More controls on pivot table columns would be a great addition so I’ll mark this as a feature request for the QuickSight team to view!
Hi @stormsarah,
One last note here but I’m not sure if it would pertain to your table. If your months (being used for the columns) are each added in by their own value, you can ‘hide’ that column. Please refer to this article for additional information