i have dso and fiscper fields, creating line chart to show dso values of all fiscper and corresponding previous year fiscper values.
DSO formula to should all fiscper values
Avg(Aggr(avg(Aggr(distinct (deb_only_dso), debitor,fiscper,sales_grp,division)),fiscper,debitor))
iam using below function to get previous year DSO values
Above(
Avg({1<fiscper>}Aggr(avg({1<fiscper>}Aggr({1<fiscper>}distinct (deb_only_dso), debitor,fiscper,sales_grp,division)),fiscper,debitor)),12)
previous year DSO formula is working fine where there no selection on fiscper, when selecting fiscper it is not giving correct ouptut. when i filtered 2022-01, it need to show 2021-01 value, but it giving something 2023-01 , but value showing again 2022-01. kindly help me