1 Reply Latest reply on May 4, 2017 12:54 AM by Ben Powis

    Calculate and display percentage of a summed total

    Ben Powis

      Hello all,

       

      I am trying to create a website heat map, I have the number of clicks per 'panel' showing correctly, but I'd also like to show the percentage of total clicks per panel. My total clicks is a calculated field (all page views where the previous page was the homepage of the website), is this possible to achieve? Each panel has it's own sheet, but each sheet has filters so that only the correct numbers are shown - when I try to do a percentage of total calculation I am always getting 100%, because it's calculating on the filtered number rather than the full figure.

      Heatmap.PNG