As attached in the image, I am unable to see grand totals value. I have done conditional formatting for a column. Any idea how to resolve this?? I have attached packaged reference book.
In my original data I have more than 3 conditional formatted columns. It calculates the percentage for grand total, but does not show values for grand total??
And also my actual data is too huge with more than 100 columns and 10L rows. So manipulating data source also is not possible.
The functionality of computed grand totals on tables does not allow for combination with the trick of using Min(1) for conditional formatting. My suggestion would be to create a separate worksheet which provides the total values and place it underneath.