Want to replace value in a chart or table within heirarchy script
Hi,
I have a multi-fact table which records data at three different levels C = Course, CP = Course Period and SUB = Subject. I want to create charts which show all the SUB (Subjects) but has the Withdrawal Date at CP (Course Period) displayed against the SUB (Subjects) rather than the Withdrawal Date at SUB (Subject). The attached spreadsheet will help you understand what table looks like for one entry at Course, Course Period and Subject and what I'm trying to achieve. I'm not sure if this is best achieved in the script or in the chart/expression?
All help would be appreciated. Below is a bit of my script.... E_END is Withdrawal Date and E_TYPE is C,CP and SUB