2 Replies Latest reply on Jul 30, 2012 11:24 PM by Per Strid

    Table Calculation

    Per Strid

      What if I want to build an "Excel looking" report and have a difference column over several measures?

      I don't get this. I can add several measures on separate rows and create a filter that keeps last two months. I can also add row totals.

      I want the difference between all my measures over the two months...

       

      Se my attached image (TableCalc.jpg).

       

      Best regards!

      Per

        • 1. Re: Table Calculation
          Tracy Rodgers

          Hi Per,

           

          This can be done by right clicking on each of the measures that are on the view and selecting Quick Table Calculation-->Difference.

           

          However, to have the original values, another instance of each measure will also need to be placed on the measure values card.

           

          Hope this helps!

           

          -Tracy

          1 of 1 people found this helpful
          • 2. Re: Table Calculation
            Per Strid

            Thanks Tracy!

             

            I built it that way first, but the "Excel People" want the numbers side by side...

            However I will make it this way and then add graphs so they will see the use of that, i hope.

            People are so used to tables and find it hard to see better ways.

             

            /P