1 Reply Latest reply on Jul 25, 2016 2:01 PM by diego.medrano

    How to get a grand total and still do what a look up function does?

    Habeeb Mohammed

      HI,

      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.