Pivot Table Sorting

[shreyguptatechie]

Hi All, 

I have a Vizlib Pivot table chart and I want to sort the Product dimension as 1-Deal, 2-Hubbing, 3- ITFS and so on.

when I am making month selection it is changing the sorting order. Please find below the snippet when i am selecting Apr25 as period. Can anyone please help and suggest.

Thanks in advance. 

[Chanty4u]

Try this 

Match([Product], '1-Deal', '2-Hubbing', '3-ITFS', '4-XYZ', '5-ABC')