For this i must thank Mr Milda for his help , below is the link :-
This report features :-
1) show each company purchase by brand by %.
2) sort high to Low by company
3) highlight those purchase % highest in RED.
This report help to allocate the right staff to the right customer , in order to improve product focus and productivity.
In order to use 8020 , we need the 8020 table report.
1) Can allow user select the pre-define dimension and expression.
1) Diamension width auto reduce to smaller size , cause need to manuallyadjust the width of diamension.
2) econvert table to chart need to initialise before next variable is select
If you have report 1 pages which is able highlight all the analysis for Segment or Brand.
So this program will be very suitable for you to export all chart to one ppt page. don’t need to copy and paste one by one. In the past i screen capture the whole page and save as image file and paste to PPT , this approach the dis-advantage is the image will not be very clear compare to this.
Quarterly brand analysis report :-
1) Now the macro only can export chart unable to export Table.
For download pls move your mouse to below link and right mouse click and select save as
Above file is my QV file use for Test new code. it does not have Target data file.