Sorting issue in Dynamic PivotTable

nihhalmca — Fri, 24 Oct 2025 22:12:18 GMT

Hi All -

I am facing a sorting issue in the dynamic pivot table.

Dim Inline table:

[

Dim_id: 1,2,3,4

Dim_list: Qtr, Month, Account, Product

Dim_label: Quarter, Period, Account, Product

]

Measure Inline Table:

[

Measure_id: 1

Measure_list: Sum(Amount)

Measure_label: Net Amount

]

Fields and Values:

Qtr, Month

Q1, Aug25, Sep25, Oct25

Q2, Nov25, Dec25, Jan26

Q3, Feb26, Mac26, Apr26

Q4, May25, Jun26, Jul26

Seems sorting is not working due to dynamic selections. We are using the below expression as dimension in pivot table.

Dim1 exp: =$(=subfield(concat(distinct Dim_list,'+',Dim_id),'+',1))

Dim1 label: =subfield(concat(distinct Dim_label,'+',Dim_id),'+',1)

Measure1 exp: =$(=subfield(concat(distinct Measure_list,'+',_measure_id),'+',1))

Measure1 label: =$(=subfield(concat(distinct Measure_label,'+',_measure_id),'+',1))

Is there any way to implement sorting dynamically like adding one more field as dim_sortorder in an Inline table.

Applying sorting order in table properties manually is not working.

Note: Dynamic PivotTable contains more than 40 fields.

Thank you for your help.

Re: Sorting issue in Dynamic PivotTable

robert_mika — Sat, 25 Oct 2025 17:24:43 GMT

Did you try using: Sort by expression option

nihhalmca — Sun, 26 Oct 2025 07:02:21 GMT

Hi Robert - Yes, i tried it.