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

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 5 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

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts