How to show the Total of Measure1 as Total of Measure2 in Pivot Table

[#1]

Dear All,

Hope Doing Well.

I have a Query to show the Sub Total of one Measure to Sub Total of Measure2.

For Example I am Having the Store Customers & Section Custmers Separately Whenever i am showing in Detail Level i need to show the values of repective one.But for Subtotal of both should be total customer of Store.

Please gothrough the attached example for more information

Regards,

Santhosh Kumar G

[danielrozental]

Sorry but I'm not able to understand what values are wrong and what would you like to show.

[#3]

Dear Daniel,

Values are perfect.

My  issue is i need to show the all values as it is.but i need to show the subtotal of Store customers to all measures like Dept.Customers & Section Customers.

Regards,

Santhosh G

[danielrozental]

sorry but i still don't get it, can you show me in an excel sheet exaclty what value show appear at what cell?