How to show sort ordered headers in a Pivot Grid in Bold BI?

When working with a pivot grid, you may want to fix the sort order in the pivot grid headers to specific values, such as JC1 to JC12. This can be achieved by following these steps:

Step 1: Create an Expression Field

Create an expression field using the following formula:

IF([Jc_Month]='JC1',1,IF([Jc_Month]='JC2',2,IF([Jc_Month]='JC3',3,IF([Jc_Month]='JC4',4,IF([Jc_Month]='JC5',5,IF([Jc_Month]='JC6',6,IF([Jc_Month]='JC7',7,IF([Jc_Month]='JC8',8,IF([Jc_Month]='JC9',9,IF([Jc_Month]='JC10',10,IF([Jc_Month]='JC11',11,12)))))))))))

Step 2: Set Row(s) Field Sorting

Set the Row(s) field sorting as Data source Order.

Step 3: Set Column(s) Field Sorting

Set the Column(s) field sorting using the expression field as follows:

Now, the Pivot grid will render as follows, even while filtering.