2 Replies Latest reply on Feb 3, 2012 12:29 PM by aliceprins

    How to disable auto calculation when filtering

      Hi,

      I have got a dashboard showing a 12 month rolling market share (done through a moving calculation of a sum + % of total) by competitor. When I activate the filter to allow users to filter for a certain awarding body, it recalculates the market share and it shows 100% rather than the original value in the full table. How can I get arround this issue?

       

      Many thanks

      Frederic