2 Replies Latest reply: May 15, 2014 9:57 AM by Lynette _ RSS

    Summary Crosstab totals n exporting summaries with colouring

    Lynette _

      Hi,

      Am using a 2 reports similar in all respects except in one the amounts are in USD and in the other the amount is in the local currency.

       

      When displaying currencies accross i both currencies alongside alongwith a total. The total is the sum of (USD+local currency) which obviously is incorrect. How can I hide this column

       

      Am using V7 pro.

       

      As an example:

                           Currency

      Details              USD  INR  Total

      xxxxx                10   500    510

      yyyyy                20  1000   1020

       

      Another request:

      Is there anyway to export the colouring I apply in summaries to excel?

       

       

      I need to hide this incorrect total column.