2 of 2 people found this helpful
We can do this using Parameters.
Select Hierarchy and you will see the Table and Bar Chart Changing (Adding or Removing Hierarchy)
A round about way but should give you the result
See attached worksheet 9.2
Hello Chandra and Takaaki,
thank you very much for your answers :-)