Sorting YOY with rolling logic

[manoranjan_321988]

Hi all,

Attached my sample data & QVF, in the qvf u can find a graph chart where sorting has issue,

1)

requirement they want two bars to compare current and pervious month,

example Aug 2025 has to  be compare to  pervious Aug 2024--- expressions achieved 

2) Now the issue is, the bar chart has to be rolling 12 months logic example

user select aug2025 in the top filter  it has to be in --->       sep oct nov dec jan feb mar apr may jun july  aug 

another user select jun 2025 or any filter on the top  it has to be in rolling 12 months --> 

july aug sep oct nov dec jan feb mar apr may jun

so need support help and solution o nt his

[manoranjan_321988]

Hi Team any help or solution on this

[manoranjan_321988]

@olofmalmstrom  any help on this sorting

[manoranjan_321988]

any help team or @olofmalmstrom  any solution from ur side , it can help me lot

[manoranjan_321988]

Team any help for this sorting issue