To get G.Total in table calculation is quite a bit troublesome.
Create Union to duplicate data.
if attr([Table Name])="Sheet1_flat" then sum([Call]) else window_sum(sum([Call]))/2 end
[Max call 2]
if attr([Table Name])="Sheet1_flat" then [Max Call]
else window_max([Call 2]) end
[% to Max2] // because of duplicated data, nneds to be divided by 6.
if attr([Table Name]) ="Sheet1_flat" then [% to Max] else window_sum([% to Max])/6 end
if [Table Name]="Sheet1_flat" then [Group] else "G.ttl" end
And one more thing.
G.Total's behavior is different from the version, so the solution might be different if you are using other version.
Table_calcgtotal_SM_9.3.twbx 26.4 KB
Thank you for the very thorough explanation Shin, this worked perfectly, thank you for your help!
You are welcome and I'm little bit surprised you could do it only by one instruction.
It's pretty complicated, good job David..