1 Reply Latest reply: Jan 11, 2016 12:46 PM by Toufique Sayed RSS

    Master Item Function - Average of Total

      I need a master item which will function as an If statement.


      Vendor Small.PNG

      I have a series of values, each with a yes of a no. How do I add a master item which would tell, if yes for column A, then total. That total would then need to be divided the total of every possible value. So ideally it would would give you percentage of spend fulling under that specific category.


      I am not able to adjust the excel sheet, or I would just make the changes there. Even when I try to do a simple average master item it says it is an invalid dimension.


      Your help is most appreciated