Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Did you try using: Sort by expression option
Hi Robert - Yes, i tried it.
