3 Replies Latest reply: Aug 2, 2013 2:13 PM by Srikanth P RSS

    Showing only one value on Pivot table Partial Sums -- Problem with one expression

    Srikanth P

      Hello folks, I created the Pivot Table and I used Partial sums option on the my dimension (Quarter).

      I have 3 expressions: 1.Actual 2. Budget or Forcast (Based on selections) 3. Variance

      I created the YTD by selecting Partial Sum value on the Quarter dimension and I selected indent mode.

      If user selected 'Budget' in the selections , the YTD for Actaul, Budget and variance showing correctly.

      But if user selected 'Forecast' in the selections, the YTD for Forcast showing only Q2.

      Please find the attached document.

       

      Can anyone face this problem before ?

       

      Any insights to solve the problem

       

      sample qvw attached