Pivoting / Totaling / Exporting to excel

  • Hi

     

    Is there a way to export the totals in a matrix report to excel as a formula and not just as summarize ?

    Because if they now delete details in excel the total remains the same total.

    Thx in advance

    El Jefe


    JV

  • Have you tried selecting the formula instead of a summation?

    ie: select '=A1-B1'

  • Well no, because we have used the subtotal function.

    So we should not use the subtotal function but create are own subtotal ?

     

    Kind regards


    JV

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply