1 of 1 people found this helpful
Currently, there is no way around adding the grand total to a table calculation and keep it hidden. My best suggestion around this would be to get the desired grand total on a separate worksheet and place the two sheets on a dashboard together. Hope this helps!
Yes, had that as an option I was working with...but was hoping for a more elegant solution
If you would like a more elegant solution, please post a sample packaged workbook that represents your situation, and there may be an option.