• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Question on Conditional and Complex formulas

    Hi Luke, Have you read my last message is it clear for you or you need some explanation. Regards
  2. M

    Question on Conditional and Complex formulas

    Thanks a lot luke it works perfectly but i think i didn't communicate one more thing all the KPIs are independently checked only in case of 100% achievement but in case if sales achievement is more than or equal to 110% than discount should also be less by 10% means 5.85% meaning both should be...
  3. M

    Question on Conditional and Complex formulas

    Dear All, I would like to have a solution on the below complex calculations. Please help if anybody has a solution for this calculations. Below is the conditions table Targets Incentive Split Sales Discounts Supply Safety Sales Discounts Supply Safety 100% 6.5% 95% 3...
  4. M

    How to minimize the Large excel size

    Hi Everybody, I would like to share a bit of challenge i am facing with excel sheet these days i have a file that has a huge data records upto 800k rows of data and coulums upto"Z" i have only one sheet in this workbook and i saved it as .xlsb in order to reduce the file size i am using excel...
  5. M

    Help in Formula

    Hi Narayan, Thanks you very much for your help and solution it works perfect but could you please explain how you did it. Its very important for me know how it works because it will help me big time in future. I tried to sum up returned value its giving me a #NAME? and when i press F2 i see...
  6. M

    Help in Formula

    Hi Narayan, Thanks for taking your valuable time and checking it. I amstill trying for it and will wait for your suggestion anyway i need it by comming Monday. Thanks Max
  7. M

    Help in Formula

    Hi Narayan, Thanks for your advice but when i try the formula its not working with the other two drop downs in the dash board. Could you please please check the attached sample sheet and propose the full solution. PLease anybody know the solution could you please propose the full formula...
  8. M

    Help in Formula

    Thanks Hui, I didn't the idea I would appriciate if you could do this in the sample sheet i have attached. Thanks in advance. Thanks Max
  9. M

    Help in Formula

    Hi Experts, Anyone can help on this? Thanks Max
  10. M

    Help in Formula

    Thanks Luke, Thanks for your suggestion but if i want to use the formula that i am currently using what will be the formula for this to achive the desired result. Thanks Max
  11. M

    Help in Formula

    Thanks Guys, PLease see the sample file link below. http://dl.dropbox.com/u/79363919/Test%20Dash%20Board%202012.xlsx Point1. Now i want to select region # 3 and the branch selection is "All" i want to display total value for all the branches in this region based on the class selected or...
  12. M

    Help in Formula

    Thanks Luke, Yes, your right thanks for highlighting it i removed it from the formula but i wnat to attache the sample sheet in order to give you the idea what i nactually needed how can i attach the sheet. Thanks Max
  13. M

    Help in Formula

    Hi Everyone, I am working on a Dash board and have created 4 different list values and i want to display the data in the table below to show the numbers based on my selection criteria in each list. Right now i am using IF condition with SUMIF function but its working fine with me for only 2...
  14. M

    Multi-Cell Goal Seeker

    Thansk Mr. Faseeh, How to add this add in excel could you please eloborate. How to use it once the addon is available. Thanks
  15. M

    Multi-Cell Goal Seeker

    Hi, its a great forum and i thanks everybody who shares and provide solutions for the people in excel. The goal seeking feature of Excel is great - if you just do a few cells. But if you have to do goal seeking on many cells, the work gets painful fast. Can we do Multi-Cell Goal Seeker for...
  16. M

    How to calculate a item in the pivot table

    Thank you very much Mr. Narayan but if i have 12 consecutive months i have to calculate one formula each for every month and then i can see the perc_Diff. Is they any other smart solution to do this?
  17. M

    How to calculate a item in the pivot table

    Hi Narayan, Its not clear its opening in some other language which i don't know
  18. M

    How to calculate a item in the pivot table

    Faseeh, Here in sales we do both comparison how you are performing vs. target and how you are performing vs last year for the same month. For example my sales last year i.e. 2011 feb is 900 and my target for 2012 feb is 1000 and and sold 800 so i achieved target 80% and vs. last year i am...
  19. M

    How to calculate a item in the pivot table

    Thanks Mr. narayan, I did try it but its not working its giving me a message "Pivot table formulas can only refer to items in the same field as the calculated item" coulds you please post an example of what you are trying to explain it will be great. I appriciate and thank you for your effort.
  20. M

    How to calculate a item in the pivot table

    Hi Faseeh, Thanks for your feedback but here i am not asking for how to compare the performance of sales Vs. target.In the attachde file your comparing sales vs. target achived What i need to know how to calculate the performance of sales of 2012 Vs. 2011. I hope you understand exactly what...
  21. M

    How to calculate a item in the pivot table

    Could anyone here help me to know how can we calculate the growth 2011 vs. 2010 for each salesmen. Thanks
  22. M

    How to calculate a item in the pivot table

    Thanks faseeh but my question was how can we calculate to compare 2012 vs 2011 in the example that you have posted in excel
  23. M

    How to calculate a item in the pivot table

    Could anybody help me to know how we can calculate the field item in the pivot table
  24. M

    How to calculate a item in the pivot table

    Thanks for your input but in real we will have tens and thousands of records and we like to summarize in then we need pivot table then how it can be done in the pivot table that was my question
  25. M

    How to calculate a item in the pivot table

    Hi, everybody i would like to calculate the item field in a pivot table. example is shown under. Salesmen Month year Sales Allan Feb 2011 1,500.00 Allan Feb 2012 1,600.00 Mullen Feb 2011 2,000.00 Mullen Feb 2012 1,900.00 Dullen Feb 2011...
Back
Top