I have a work sheet where I am getting counts from previous months using LOOK_UP function but unable to get Grand_Totals. I am aware that look_up is a Table calc function while the grand totals are calculated first before table calcs are executed and this is why I am not getting my totals. But my requirement is that I need to see both, grand totals and look_ up values. Is there an alternative to LOOK_UP where I can get the grand totals as well? Appreciate any suggestions. Thanks.
Your best best is to create your own grand totals instead of using the built-in buttons. I would try this tutorial: