4 Replies Latest reply: Oct 11, 2010 4:55 AM by mmazelei

# PIVOT table: need to  an expression is only function a part of dimension to my pivot table

hi,

i make a QVW for explain my problem;

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

• ###### PIVOT table: need to  an expression is only function a part of dimension to my pivot table

Hi,

If you are looking for having TASK as the only dimension for ETC,

then you can use this logic:

Please let me know if it works. Also, feel free to ask if that is what you are not looking for.

• ###### PIVOT table: need to  an expression is only function a part of dimension to my pivot table

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 ETC) SUM(ACTUAL) SUM( TOTAL ETC) SUM(ACTUAL) SUM( TOTAL 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 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

• ###### PIVOT table: need to  an expression is only function a part of dimension to my pivot table

In that case, you can have that a calculated dimension:

And, of course, remove it from Expressions.

(For formatting purposes, please promote that above TIME)

Let me know if this works.

• ###### PIVOT table: need to  an expression is only function a part of dimension to my pivot table

hi rocky,

it works very well and thx for your help and maybe this topic could be help someone else.