0 Replies Latest reply: Apr 17, 2013 7:00 AM by Udo Rädeker RSS

    Conditional InputSum In PivotTable

      Hi,

       

      in this PivotTable the Column "Verkaufte Lizenzen" should be Inputfields.

      It works, when I just declare InputSum([Verkaufte Lizenzen]).

      The result is:

      CondInputSum0.JPG

       

      I just want the input field if Dimension Ziel = "Lizenzverkauf"

      So I defined a condition:

       

      if (Ziel='Lizenzverkauf',InputSum([Verkaufte Lizenzen]))

       

      But when conditioning the input by an IF-Condition it won't by an InputField more

      and the manual input value is show in the correct row.

      CondInputSum.JPG

      I want this and an inputfield as well. Is there any chance to manage this?

       

      THX in andvance and best regards.

       

      Udo