I've created a what if analysis and ve put subotal on top from proerties settings. I'm getting the subtoal for all fields when im changing the slider value. But when i further drill down in pivot i'm only getting the sum of the field selected.
I want even if i drill down in pivot i shud get the subotal. Hope someone can help me with this....
On the Presentation tab of the properties screen check Partial Sums for the dimensions that you want to see subtitels for. If you change the dimensions in the chart to a drilldown group don't forget to enable the Partial Sums for the group. If you remove a dimension from the chart then the Partial Sums option for that dimension is removed too. It doesn't automagically reappear if you later add that dimension again.
Hi Gysbert, i've tried wat u ve suggested it is still showing the same result. I'm getting the subtotal but when i select select any 1 field and change the slider value it shows me the sume of the selected field only.....
