Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have a straight table
my dimension is -resource name
my expresion -sum({<project name=>}effort_hours)
my problem - when im choosing in a list box a project name i want to see only the resource name that taking part of this project,
but i see all of my resources becouse of the expresion.
what should i do to see only the resources that taking part of the project?
adi
Try like:
Sum( {1<Resource=p({<[project name]=p([project name])>})>}effort_hours)
in your expression you define that you want to see all sums regardless of selection of project names
So if you only use sum(effort_hours) you will only see the sum for the seletced projects.
But maybe you have another intention?
hi,
tnx but i need to keep the expresion like it is.
Hi adi,
if i understand u r requirement properly,
i am suggesting u the expression to use as
Sum([Effective Hours])
and dimension as Resource Name
if you want to see only the resources related to your selection you should change the expression to sum(effort_hours)
i want to see only the resources related to my selection BUT i want to see their effort hours in ALL of the project not just their their effort hours of the selected one...
?
if you only want to see the overall effort (despite the selection)
you can use: sum(total <project name> {<project name=>}effort_hours)
but the user will see a result which does not belong to his selections (means: user selected a project
and gets the overall effort).
But maybe I misunderstood your requirements?
yes, the expresion is fine but my problem is -
i want that the table will show only rows of resources that related to the project.
and now i see all of my resources.
hope its clear
Try like:
Sum( {1<Resource=p({<[project name]=p([project name])>})>}effort_hours)