1 Reply Latest reply on Aug 18, 2017 10:46 AM by Hari Ankem

    Subtract subtotal

    Alex Martino

      If you have two months and values, can you create another row (like an income statement) that sows the difference between the two months. i created a formula but not sure how to format or get it to show up in a crosstab.

        • 1. Re: Subtract subtotal
          Hari Ankem

          You can do it in 2 ways:

          1. Have an additional blank row in the data itself and then manipulate it to show what you want.

          For example: I have created a similar output using the Superstore data.

          Capture.PNG

          2. Create 2 separate worksheets, one for the 2 months data, and the second for the difference/variance and place them both on a dashboard one above the other.