Pivot table - display parameter on column header

Question & Answer
,
1

As sorting of filtering control is only alphabetical ascending order, list of values for paramAsOfMonth is prefixed with NN as below.

image
image202Ă—412 10.8 KB

In Pivot Table, when using paramAsOfMonth

image
image236Ă—196 6.76 KB

it is showing the prefix NN as well.
image

Is there any workaround to display paramASOfMonth without the prefix NN?

Thanks.

2

Hi @lbl

At AWS, our roadmap is primarily driven by our customers.
Your feedback helps us build a better service, I have tagged this as feature request.

In the meantime you might change the value of the parameter control with empty space added ( twelve space for Jan to one space for Dec) .

image
image1483Ă—440 25.9 KB

Thanks
Vinod

2 Likes
3

@apjvinod
Adding of empty spaces solves the sorting in parameter control. Thanks!

Will formula on the “Value names” be included as a feature request?
e.g. instead of showing “Last Month”, able to use formula on parameter values to work out actual month e.g. Dec

4

Hi @lbl,
Yes, that can be part of the feature request.

Let us know if you have any additional questions regarding this post, otherwise, if we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!