jmac001
asked on
Part 3 - Chart 3 Top 6 Top 3
Chart 3 - Top 6, Top 3 (similar to Chart 1)
Pie 3 (right) - picks data from sheet - Budget; COST pivot table from PIVOTS.
1. The Table COST should at all time be filtered by the Status OPN and then perform calculations.
2. When creating the Top 6 Reason Codes I would like to have the reason code ON-BDGT excluded from the results.
3. Top 3 will be the stores with the highest variances found in Column M of the Budget worksheet.
4. Would like the results to look as follows:
Partner- Site, 13s 25%
Mila-57115 - 57%
Jem-57675 - 54%
Stoc-56225 - 44%
EE-Test-Scorecard-2014.02.21-Cha.xlsm
Pie 3 (right) - picks data from sheet - Budget; COST pivot table from PIVOTS.
1. The Table COST should at all time be filtered by the Status OPN and then perform calculations.
2. When creating the Top 6 Reason Codes I would like to have the reason code ON-BDGT excluded from the results.
3. Top 3 will be the stores with the highest variances found in Column M of the Budget worksheet.
4. Would like the results to look as follows:
Partner- Site, 13s 25%
Mila-57115 - 57%
Jem-57675 - 54%
Stoc-56225 - 44%
EE-Test-Scorecard-2014.02.21-Cha.xlsm
2 things:
1) I noticed in PIVOTS COST you have beside ON-BDGT that we need to remove you also have (blank) Store shall we remove this one as well ?
2) If we remove these 2 should we do it from the PIVOT table like filter the pivot without these 2 items ? this means that
instead of having what we have now
ON-BDGT 34
PAR-SITE 13
(blank) 2
SDC-DESN 2
BRD-AGMT 1
Grand Total 52
We should instead have:
PAR-SITE 13
SDC-DESN 2
BRD-AGMT 1
Grand Total 16
Is that Correct the total is now 16 and not 52 ???
3) Then we are looking for Top6 but here we have only 3 so we should go to minimum what we have items not to exceed 6 Is that logic correct ???
As we are not using this logic anywhere else.
gowflow
1) I noticed in PIVOTS COST you have beside ON-BDGT that we need to remove you also have (blank) Store shall we remove this one as well ?
2) If we remove these 2 should we do it from the PIVOT table like filter the pivot without these 2 items ? this means that
instead of having what we have now
ON-BDGT 34
PAR-SITE 13
(blank) 2
SDC-DESN 2
BRD-AGMT 1
Grand Total 52
We should instead have:
PAR-SITE 13
SDC-DESN 2
BRD-AGMT 1
Grand Total 16
Is that Correct the total is now 16 and not 52 ???
3) Then we are looking for Top6 but here we have only 3 so we should go to minimum what we have items not to exceed 6 Is that logic correct ???
As we are not using this logic anywhere else.
gowflow
ASKER
Hi gowflow
1. Yes I would like to have the blanks excluded from the top 6 results, however I would like them to remain in the pie chart.
2. The correct total would be 16
3. Yes the logic would be not to minimum of what is in the data and not to exceed 6 reason code
1. Yes I would like to have the blanks excluded from the top 6 results, however I would like them to remain in the pie chart.
2. The correct total would be 16
3. Yes the logic would be not to minimum of what is in the data and not to exceed 6 reason code
all is ok except you said:
3. Yes the logic would be not to minimum of what is in the data ....
I guess you meant:
3. Yes the logic would be minimum of what is in the data and not to exceed 6 reason code
Pls confirm
gowflow
3. Yes the logic would be not to minimum of what is in the data ....
I guess you meant:
3. Yes the logic would be minimum of what is in the data and not to exceed 6 reason code
Pls confirm
gowflow
ASKER
Yes, I apologize I did mean the logic would be minimum of what is in the data.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi gowflow,
Testing will update and let you know if I identify any issues.
Thanks
Testing will update and let you know if I identify any issues.
Thanks
ok fine let me know.
gowflow
gowflow
Any news on your trials ?
gowflow
gowflow
I take it that the solution worked for you as you did not comment. Pls advise if you need further help on any other issue by posting a link in here.
Regards/gowflow
Regards/gowflow
Hi jmac001
I usually keep the last question opened or monitored for people who I worked extensively on certain items which happen to be your case.
Would you need other help in the future or its okay if I close this question ?
gowflow
I usually keep the last question opened or monitored for people who I worked extensively on certain items which happen to be your case.
Would you need other help in the future or its okay if I close this question ?
gowflow
... working on it
gowflow