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

    Conditional InputSum In PivotTable



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

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

      The result is:



      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.


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


      THX in andvance and best regards.