1 Reply Latest reply on Nov 30, 2016 4:09 PM by Shinichiro Murakami

    Summing the visible data, not all the data

    Chris McClellan

      Because of the structure of my data, I have to use a combination of dimension filters and measure filters to display the desired data in the view.

       

      I've actually got 64 rows of data in the view, but I only really want to add up the last X (where X changes depending on some other data conditions, but it's currently 12).

       

      If I add INDEX() into the view, the values returned are 53 to 64 for each of the last 12 rows, so I know there's 64 rows of data and the measure filters are working properly to only show the last 12.

       

      How do I create a calculated field (or any other structure at this point) that only totals the visible rows (ie after the measure filter has been applied), and not all the rows ?