This content has been marked as final. Show 3 replies
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