How to show one store's total next to its related region's total?

[ekedubois]

Hello,

How to show one store's total next to its related region's total?

Thank you

 

[ekedubois]

Here is a "screen shot" to illustrate my question:

Sum of Gross Total Column Labels
Row Labels__2011____2012____2013____2014_____Grand Total
Eastern_____$601,648 $471,350 $512,028 $259,528 $1,844,555
1004________$601,648 $471,350 $512,028 $259,528 $1,844,555
Grand Total__$601,648 $471,350 $512,028 $259,528 $1,844,555

I am trying to have the region total be The region total and not just a repeat of that of the location "1004".

 

[HillDragon]

My guess is that your tables look something like this?

If so, you need to keep in mind that the arrow is to tell you what tables it will receive "instructions" from. i.e. how to filter, sort, and compare it's own data.
In the image above, filtering the Sales or the Regions tables will effect SomethingElse but they will not effect each other.

 

[ekedubois]

HillDragon, I have only two tables. "All" and "References". The later is used for a very few related matters (lookup of zipcodes, true/false).
At this point I have to work on more important matter. c I'm starting a new thread.
Thank you for your time and input.

 

[scottsen]

I'm not SUPER clear on your question, but I think if you select the region cell, and use the Field Settings to change layout to "tabular form" you might get what you want?