1 Reply Latest reply: May 30, 2012 10:02 AM by Nicole Smith RSS

    Pivot Table keeping value constant, when user enters value

      Hi,

       

      Please see attachment; before reading:

       

      I basically have this, now when the user selects Company A, I do no want anything to change in the below table i.e If the user selects

      a Company then I want to see

       

      A    -----  50 (I do not want this to change to 100, I want is to remain 50 even though the user selected a Company).

       

      I understand why this happens with the current logic that I am using in the expression i.e.

       

      count(Transactions)/count(Total Transactions).

       

      I have tried to use count(Transactions)/count(All Transactions), but I do not want all the Transactions for eg. April's Data.

       

      Any Help will appreciated. 

       

      Kind Regards

      Razak

      Capture.PNG