You probably would need to do a calc like IF LAST()=FIRST() THEN...
This will force the value you want when there is grand totals turned on. Without seeing an example workbook I won't be able to help more than that. If you are able to load up a packaged workbook I can probably help further.
Please see attached in version 9.1
Have two issues.
1) The Volume column is a formula that adds and subtracts some of the other columns in the work book.
One component of the formula is the "mix" column. The mix calculation works for the individual row items. However
it does not provide a grand total. This is because the grand total for mix is a product of a percentage which is zero in the grand total times the sales difference dollars field.
However when you download and cross tab the volume column you get a +68,000 rather than the negative 108,000. Again the actual row values for each transaction
Believe the mix calculation might be interfering.
My objectives are as follows:
1. Would like the grand total for the Volume column to total correctly .... ~68,000
2. Have the mix total -45,000 which is what the cross tab data shows.
Perhaps there is a workaround to just add up the row values in the mix column to provide a total. Real value is -45,000.
And for the Volume column to add correctly.
History TESTING.twbx 511.9 KB