Not sure if this will work for your true dataset,
but you can try unioning your data to itself.
This will generate a new field called [Table Name]
which you can use in calculations.
So to make the division you desire, you can use a calculated field of:
IF [Table Name]="Orders" THEN [Segment] // this is copy one
ELSE "Total" // this is copy two
Then I put [Segment] on the Color Shelf.
Please see workbook v10.3 attached in the Forum Thread:
287076union.twbx 1.2 MB
Thank you but I'm trying to avoid union for doubling the data. it's too complicated for what I'm really doing so it's not a sustainable process.