Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i make a QVW for explain my problem;
dimensions: TASK,PROJECT,TIME
expressions: SUM(ACTUAL), SUM(ETC)
Currently my 2 expressions are function of all dimensions in qvw and i would like SUM(ETC) expression is function of only the dimension TASK (not all dimension)
if someone can help me please
Hi,
If you are looking for having TASK as the only dimension for ETC,
then you can use this logic:
sum(TOTAL <TASK> ETC)
Please let me know if it works. Also, feel free to ask if that is what you are not looking for.
thx rocky,
it is i would like in formula but don't in presentation,
currently l have
TIME | 2008 | 2008 | 2009 | 2009 | 2010 | 2010 | |
PROJECT | TASK | SUM(ACTUAL) | SUM( TOTAL <TASK> ETC) | SUM(ACTUAL) | SUM( TOTAL <TASK> ETC) | SUM(ACTUAL) | SUM( TOTAL <TASK> ETC) |
PROJECT1 | TASK1 | 2 | 15 | 8 | 15 | 11 | 15 |
PROJECT2 | TASK2 | 0 | 3 | 2 | 3 | 0 | 3 |
PROJECT2 | TASK3 | 3 | 1 | 0 | 1 | 0 | 1 |
PROJECT2 | TASK4 | 0 | 3 | 4 | 3 | 0 | 3 |
PROJECT2 | TASK5 | 0 | 3 | 0 | 3 | 1 | 3 |
i would like (i dont want a duplication my expression for each YEAR (TIME)
TIME | 2008 | 2009 | 2010 | ||
PROJECT | TASK | SUM( TOTAL <TASK> ETC) | SUM(ACTUAL) | SUM(ACTUAL) | SUM(ACTUAL) |
PROJECT1 | TASK1 | 15 | 2 | 8 | 11 |
PROJECT2 | TASK2 | 3 | 0 | 2 | 0 |
PROJECT2 | TASK3 | 1 | 3 | 0 | 0 |
PROJECT2 | TASK4 | 3 | 0 | 4 | 0 |
PROJECT2 | TASK5 | 3 | 0 | 0 | 1 |
In that case, you can have that a calculated dimension:
=aggr(sum(ETC), TASK)
And, of course, remove it from Expressions.
(For formatting purposes, please promote that above TIME)
Let me know if this works.
hi rocky,
it works very well and thx for your help and maybe this topic could be help someone else.
PROJECT | TASK | =aggr(SUM(ETC),TASK) | TIME | 2008 | 2009 | 2010 |
PROJECT1 | TASK1 | 0 | - | - | 11 | |
PROJECT2 | TASK2 | 3 | - | 2 | - | |
PROJECT2 | TASK3 | 1 | 3 | - | - | |
PROJECT2 | TASK4 | 3 | - | 4 | - | |
PROJECT2 | TASK5 | 3 | - | - | 1 |