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...
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...
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...
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...
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
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...
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
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...
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
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...
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...
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?
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...
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.
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...
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
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...