I checked your workbook and find that your "Stage Trend" is not calculated field.
Then if that has multiple value in data as "String", G.Total will how both value.
I added calculated field as "Dummy_Trend"
IF sum([TCV])>SUM([2016 rev Impact]) THEN "UP" ELSE "FLAT" END
In this case, G.Total follows the formula.
So, if you can replicate "Stage Trend" as calculated value, you can fix the problem on G.total.
Thanks for your response Shin but I'm looking for Grand total for TCV and 2016 Rev Impact.....
I used to have them both as continuous measure but had to switch to discrete to get a shape for "Trend Stage" that's when I lost the grand total for TCV and 2016 Rev Impact. So even if I do a calculated field for Stage Trend - Grand total not working for TCV and 2016 Rev Imapct
Thank you so much Shin!!! I appreciate your time!
I'm almost there!
I got the totals but my Tittles are gone....I noticed you had six MIN(Number of records) vs I have three....was it to create the title? I couldn't tell what you did with three that had shape assigned to it...sorry to be needy but stuff like this takes hours to figure out...
thanks for your help
Please wait a while. I will post it in a couple of hours.
It's not difficult, but a little bit troublesome....
You are awesome!!! Thank you so much!