Total should be same in pivot tables for different dimensions

[Anonymous]

Hi

I want total of all the stores on the basis of different dimensions to be same in a pivot chart

[vishalarote]

Go to Properties->Presentation->Show Partial Sum

on that checkbox show Partial sum for each dimention

[vishalarote]

And Also on Subtotal at Bottom Checkbox for the same path

[Anonymous]

The total of each pivot tables (gender and dist channel ) chart should be same ie total stores should be 408 for each dimension in pivot table

[Anonymous]

I want NSV value for different charts to be same like

for eg-

In image below NSV value for before previous year is  5436.2 where dimension is Dist Channel

whereas NSV value for before year is 3769.5 where dimension is gender

so,I want values for both NSV should be same

[Anonymous]

Please check the image and figures circled in black