Quick update -- if I change some of the rows which I do not want to subtotal for to Attributes -- it works -- though this is a bit klugey and also converts some to asterisks -- which isn't correct. But, is a (very bad) workaround.
What you need is a custom partition.
From your "Pane" worksheet,
1. bring up the context menu for your table calculation pill, and select "Edit Table calculation"
2. In this dialog you will see a drop-down for "Summarize the values from" (other times this is called "Compute using"), select "Advanced"
3. In this dialog, with these two list boxes, you can set your custom partition, here is what is going on:
Dimensions on the left will cause a partition, a restart of the calculation. The combination of these values creates a partition. So if you only want to partition on "GIC_Industry", then only leave that field on the left, and move the rest to the right.
Dimensions on the right will determine the level of detail, or initial level of aggregation, and the combination of these will determine the rows within a partition.
The order along lets you sort the rows within the partition (not needed for this question, but good to know).
I suspect you want to partition on both "Entity" and "GIC_Industry", and have done so in the attached workbook.
samplesubtotals_edit.twbx 61.0 KB
Excellent! -- This worked -- thanks again,