2 Replies Latest reply on Dec 2, 2016 8:06 AM by Cedric Wood

    Column Totals

    Cedric Wood

      I have created a table with some conditional formatting.  I achieved the formatting by using a set of generic measures and creating a dual axis.  I am displaying a total of a metric by specific times of the day.  I wish to total each bucket so I used the Analysis/Totals/Show Column Grand Totals - Show Row Grand Totals.  I'm not sure why but the totals calculation is broken up into two numbers (when added together give the correct total) which appear to originate from separate cells.  I've not been able to figure out why this is occuring and more importantly, how to correct it.  In addition, the conditional formats appear to be applying to the totals.  I would like to correc this also.  Any assistance is greatly appreciated.  I've attached a sample of the wb.