Forum Discussion
YavuzDuran
4 years agoHelper III
Custom Sorting for a Calculated Column
Hi all, I have a slicer in which there is a calculated column value. I want to make a custom sort like: Current 1 Dat PD 2 - 5 PD 6 - 15 PD 16 - 30 PD 31+ PD but since this is a calculat...
- 4 years ago
Hi YavuzDuran,
for this you should use the function: "Sort one column by another column"
Acct Standing Index = IF ( AllAccounts[Actual # Days Past Due] = 0, 0, IF ( AllAccounts[Actual # Days Past Due] = 1, 1, IF ( AND ( AllAccounts[Actual # Days Past Due] > 1, AllAccounts[Actual # Days Past Due] < 6 ), 2, IF ( AND ( AllAccounts[Actual # Days Past Due] > 5, AllAccounts[Actual # Days Past Due] < 16 ), 3, IF ( AND ( AllAccounts[Actual # Days Past Due] > 15, AllAccounts[Actual # Days Past Due] < 31 ), 4, IF ( AllAccounts[Actual # Days Past Due] > 30, 5, 99 ) ) ) ) ) )
mwegener
4 years agoMost Valuable Professional
Hi YavuzDuran,
for this you should use the function: "Sort one column by another column"
Acct Standing Index =
IF (
AllAccounts[Actual # Days Past Due] = 0,
0,
IF (
AllAccounts[Actual # Days Past Due] = 1,
1,
IF (
AND (
AllAccounts[Actual # Days Past Due] > 1,
AllAccounts[Actual # Days Past Due] < 6
),
2,
IF (
AND (
AllAccounts[Actual # Days Past Due] > 5,
AllAccounts[Actual # Days Past Due] < 16
),
3,
IF (
AND (
AllAccounts[Actual # Days Past Due] > 15,
AllAccounts[Actual # Days Past Due] < 31
),
4,
IF ( AllAccounts[Actual # Days Past Due] > 30, 5, 99 )
)
)
)
)
)
- YavuzDuran4 years agoHelper III
Perfect. Worked. Thank you.