Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Is it possible to upload your application?
sample qvw was attached
The Partila Sum option, just sum the values of the expression results or calculate the expression overall on the dimension ??