Hiding values in pivot but only show total

[#1]

I created a qvw with random numbers to upload, I'm on the road, just installed QV to make this QVW.

What I have :

Dimensions:

ProfitCenter

- Project

-- Department

--- WBScode

---- Article Description

Expressions:

Budget

RealTime

Obligo

AlreadySpend

StillToSpend

Problem is : Budget is made for Diension WBScode.  QV is putting the same number (Budget) in the pivot for Article.

Is there any way I can dismiss the Budget on the level of Article and only showing the number in the totals ?

Otherwise they will think that there's a budget of € 118992.67 for Article X and a budget of € 118992.67 for Article Y.

While Article X and Y are for WBScode AL01 with a total budget of € 118992.67

THX in advance

[Anonymous]

Hi,

You can try something like this.

hope it helps.

[jonathandienst · Accepted solution]

Hi

Use this for Budget:

     =If(Dimensionality() < 5, sum(Budget))

On the presentation tab, make the Null Symbol a space character.

See attached:

HTH

Jonathan