3 Replies Latest reply on Jan 16, 2013 5:35 AM by Alex Kerin

    Add both values

    buildstar

      Hi All,

       

      I want to add the values mentioned. Due to a year filter we are getting 2 lines of the amount. How to sum the amount even if year range is selected.

       

      Thanks

        • 1. Re: Add both values
          Alex Kerin

          Can you expand your screenshot so we know what you have on the row/column shelves?

          • 2. Re: Add both values
            buildstar

             

             

             

            The first 2 and last 2 values sum up fine...only the second value computation is not matching...is it because of the data source being different?

             

            If I remove the year capsule then the addition of the individual years and the sum of the values is not matching.

             

            Thanks

            • 3. Re: Add both values
              Alex Kerin

              If something non-obvious is going on (removing the year pill should not affect these things), then there's no way were going to be able to answer this without a tbwx. In your second post you are now mentioning a second datasource. It takes forever to answer your questions because you don't give us the full information on what is happening. In non-obvious cases we need a twbx that actually represents your data set and reproduces the issue.