Column / Formula To Bar & Summary Level

Hi All,

 

Does anyone out there know of a way to display the level (i.e. in the chart structure) that a line (summay or bar etc.) is at?

 

I know you can use the Show To Level button, but was after something that could display in the column of that line automatically. I thought that perhaps it could be done through a forrmula, but after hours of trial & error (all error) I cannot see how.

 

Any info on this would be appreciated, even if its to say it can't be done.

 

Regards,

 

Chris

C
Chris Lothian 👤 Member for 19 years 1 month

Thanks Mike.

 

I was after an automated way of doing it - I'll assume as no other answers that it can't be done.

 

Chris.

M
Mike Testro 👤 Member for 20 years 6 months

Hi Chris

I use a colour code to differentiate the various levels.

The code is then displayed in the Code Column - even though that particular code is not used on the chart display.

Best regards

Mike Testro

BTW - I have cleared your double entry.

Forum Sponsor

Top Posters

Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
James Williams
74 posts
Haque Nawaz
10 posts