Forum Discussion

DarrenW's avatar
DarrenW
Frequent Visitor
2 years ago

Showing direction arrows on hierarchical data

I have a set of data with a custom hierarchy (anonymised sample below   What I need to be able to do is display the data in a grid with a final column that shows the upward or downward movement at ...
Need Help
DarrenW's avatar
DarrenW
Frequent Visitor
2 years ago

PS I tried this too

↕ = SWITCH(
    TRUE,
    Sum(Main[Change])=0," ",
    Sum(Main[Change])<0,UNICHAR(129095),
    Sum(Main[Change])>0,UNIChar(129093))
  • DarrenW's avatar
    DarrenW
    Frequent Visitor
    2 years ago

    PPS the CF I created to colour the arrows red or green seems to work fine so I'm thinking it's the 'first' summarization that's causing the problem