I inserted a pie chart... I'm inserting current year(from tree) in categories, I don't see an option where I can change the expression when i click on edit properties. Please help.
**I was trying to create an already existing report, still in learning process
The expression was like this
[HR Flash].[Year].[Year]->?param_hr_year?
what does this mean?
It is a query calculation (from the toolbox) - drop this into your Categories area of the chart, then build the expression. For the first part, drag in the Year hierarchy, then add the rest by hand.
-> is a dimensional operator, essentially used to locate a member in a hierarchy, and the part in ?question marks? is a parameter, which will result in a prompt for the relevant member.
MF.
Sent from my iPad using Tapatalk
Thank you so much... your forum is helping me a lot...