2 Replies Latest reply: Nov 29, 2013 5:32 AM by Jonathan Dienst RSS

    Hiding values in pivot but only show total

    Jochen Andries

      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