Skip to Content
0

multiple series SAP xcelsius dashboard with two(2) combo-box

Jul 31, 2017 at 03:10 PM

39

avatar image
Former Member

Good day All,

Please I need assistance with my SAP dashboard.

I am trying to create an interactive Stacked Column Chart dashboard on SAP xcelsius with multiple series.

I have created two combo boxes to filter the first column (SERVICE TYPES) and to filter the second column (SERVICE PROVIDERS).

My main challenge is mapping my data into the Stacked Column Chart after filtering with my combo-boxes.


My data is in this format:


SERVICE PROVIDER JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER APP STORE TERRAGON 18.62 32.09 22.18 42.50 0.53 16.82





APP STORE VAS2NETS 2.86 - - - - -





BACKUP MOBILISE AFRICA 6.26 5.10 5.28 5.02 4.98 4.54





BETTING 70TH PRECINCT - - 0.02 - 0.02 51.67





BETTING CLOUD 1.70 1.21 1.33 1.21 1.63 2.68





BETTING MTECH 11.58 8.11 33.28 42.93 34.74 30.94





BETTING POLO SOLUTION - - - - - -





BIDDING 70TH PRECINCT - - - - - -





CONTENT HUAWEI 75.42 66.85 76.34 89.54 86.18 83.2





DATING AKINGA - - - - 0.02 0.02





DATING AVALANCHE 0.01 0.01 0.01 0.01 0.01 0.01





DOMESTIC VIOLENCE HOLLA TAGS 0.36 1.52 1.46 0.47 - -





EASY STATUS CLOUD 2.83 4.93 7.88 12.03 17.27 36.42





EASYNEWS HUAWEI 238.94 292.30 366.79 93.39 25.04 24.85





EDUCATION BETAZOO - - 0.01 0.16 0.15 0.03





EDUCATION ICONCEPTS - - 0.01 0.01 0.01 0.02





EDUCATION IMAGINARIUM - - - - - -





EDUCATION SBSC 0.36 0.43 0.46 0.32 0.26 0.32





ENTERTAINMENT ASCENSO 39.23 32.30 32.68 25.99 25.45 18.91





ENTERTAINMENT BLACKNGREEN - - - - - -





ENTERTAINMENT EDENTEK 3.48 3.11 3.21 2.97 2.78 0.12





ENTERTAINMENT FREESIA - - - - - -





ENTERTAINMENT ICONCEPTS - - - - - -





ENTERTAINMENT NAZARA 34.46 29.07 23.69 22.32 35.50 58.65





ENTERTAINMENT STARFISH - - 0.28 0.30 0.43 0.1





ENTERTAINMENT TERRAGON - - - 0.03 3.75 -





ENTERTAINMENT VASDIG - - - - 0.33 0.43





FINANCIAL EDENTEK 2.40 2.04 1.53 1.17 1.32 0.19





FINANCIAL MOBILISE AFRICA 6.89 5.80 5.97 5.36 5.52 5.09





FOOTBALL 70TH PRECINCT 33.13 30.12 40.40 17.70 22.43 34.61





FOOTBALL CLOUD 21.29 20.96 26.08 20.41 19.28 15.91





FOOTBALL GTEL 2.00 8.29 9.90 10.73 13.47 11.3





FOOTBALL TIMWE 36.37 6.93 10.90 13.89 18.42 27.84





FOOTBALL YELLOW DOT 18.49 13.73 10.80 9.69 7.95 6.36





GAMES AGILENT - - - - - -





GAMES BINBIT 59.60 47.21 45.71 38.33 41.97 55.85





GAMES GAMELOFT 11.45 9.27 8.45 7.32 7.62 8.81





GAMES ICONCEPTS 2.36 1.61 0.83 0.63 0.85 1.29





GAMES IMAGINARIUM - - - - - -





GAMES MOBAFRIC - - - - - -





GAMES NAZARA 21.50 21.65 18.12 15.11 18.14 25.68





GAMES NTH 2.83 4.22 4.94 4.40 6.36 10.24





GAMES TIMWE 0.01 0.09 0.23 0.17 0.16 0.34





HEALTH EDENTEK 0.71 0.67 0.43 0.33 0.38 0.06





HEALTH TIMWE - - - - - -





INFOTAINMENT 1 2TOC - - 0.01 - 0.01 -





INFOTAINMENT 1 3WAYCOM 1.40 1.85 4.59 8.28 9.19 8.26





INFOTAINMENT 1 70TH PRECINCT 17.52 17.26 20.10 7.63 11.08 18.55





INFOTAINMENT 1 7COLORSDIGITAL - - - - - 0.02





INFOTAINMENT 1 9BITSMT - - - - - -





INFOTAINMENT 1 ABZAFA - - - - - -





INFOTAINMENT 1 ADNOL 0.56 0.08 - - - -





INFOTAINMENT 1 AFMOBI - 0.01 0.09 0.10 0.07 0.06





INFOTAINMENT 1 AGILENT 58.13 53.92 57.34 53.97 57.30 51.38





INFOTAINMENT 1 ALVOICMT - - - - - -





INFOTAINMENT 1 ARIAL VIEW - - - - - 0.1





INFOTAINMENT 1 ASCENSO 59.57 46.02 42.63 34.90 32.12 24.46





INFOTAINMENT 1 AVALANCHE 5.30 4.42 4.77 4.05 5.67 6.28





INFOTAINMENT 1 BDIGITAL 3.53 19.65 21.54 16.21 13.44 10.48





INFOTAINMENT 1 BETAZOO 0.02 - - 0.01 0.22 -





INFOTAINMENT 1 BILYAK - - - - - -





INFOTAINMENT 1 BLACKNG - - - - - -





INFOTAINMENT 1 BLACKNGREEN 0.52 0.44 0.43 0.41 0.41 0.38





INFOTAINMENT 2 BUSINESS SOLUTION - 0.80 10.38 14.07 21.88 19.31





INFOTAINMENT 2 CELLCAST - - - - - -





INFOTAINMENT 2 CELLULANT 0.59 1.79 0.10 0.09 0.06 0.07





INFOTAINMENT 2 CLOUD 1.00 0.55 1.81 1.49 1.43 1.52





INFOTAINMENT 2 COIGNSOFT 0.20 0.15 0.13 0.09 0.03 0.05





INFOTAINMENT 2 COMPTEL - - - - - 0.09





INFOTAINMENT 2 CP1 - - - - - -





INFOTAINMENT 2 DIGIMOB - 0.24 - - - -





INFOTAINMENT 2 DO MEDIA 0.11 0.13 0.13 0.12 0.13 0.13





INFOTAINMENT 2 DOBOX 0.01 - - - - -





INFOTAINMENT 2 DOTTXT - - - - - -





INFOTAINMENT 2 EDENTEK 35.92 1.53 1.45 0.73 0.70 0.4





INFOTAINMENT 2 ELSEJI 82.20 64.50 57.92 49.22 46.62 33.42





INFOTAINMENT 2 EMAGINE - - - - - -





INFOTAINMENT 2 EMO MEDIA - - - - - -





INFOTAINMENT 2 ERASKOM 0.01 - - - - -





INFOTAINMENT 2 ESCAPE 0.04 0.03 0.03 0.03 0.02 0.02





INFOTAINMENT 2 ESKIMI 5.06 3.86 4.92 4.02 3.42 3.04





INFOTAINMENT 3 ETRANZACT - - - - - -





INFOTAINMENT 3 FIRST ASTORIA - - - 2.41 21.62 9.43





INFOTAINMENT 3 FIRST BRIDGE INTERGRATED SERVICES LIMITED - - 0.17 2.60 7.15 14.84





INFOTAINMENT 3 FREESIA 28.60 27.48 32.65 38.97 36.59 35.75





INFOTAINMENT 3 FUNMOBILE - - - - - -





INFOTAINMENT 3 GEMALTO 0.40 - - 0.27 1.43 0.69





INFOTAINMENT 3 GENSY - - - 0.01 - -





INFOTAINMENT 3 GIDISOFT 45.31 40.18 35.51 32.27 29.25 20.77





INFOTAINMENT 3 GISTME - - - - - -





INFOTAINMENT 3 GLOBAL PRIME 10.20 11.04 21.09 25.23 47.76 55.15





INFOTAINMENT 3 GREENBEE 0.77 1.18 2.05 1.67 1.79 1.75





INFOTAINMENT 3 GREYSTONE - - - - - 0.16





INFOTAINMENT 3 GTEL 2.05 6.40 7.66 8.05 10.09 8.48





INFOTAINMENT 3 GTSINFO 0.21 0.19 0.20 0.21 0.19 0.54





INFOTAINMENT 3 HICUE 7.52 4.90 2.45 1.60 2.63 3.7





INFOTAINMENT 3 HOLLATAGS 8.25 8.21 10.27 8.85 9.20 8.93





INFOTAINMENT 3 HSCLMT 0.01 - - - - -





INFOTAINMENT 3 HUAWEI 40.41 32.89 34.55 29.98 29.32 26.1





INFOTAINMENT 4 ICONCEPT - - - - - -





INFOTAINMENT 4 ICONCEPTS 53.36 39.10 37.70 30.75 28.79 23.77





INFOTAINMENT 4 IMAGINARIUM 20.74 17.64 16.77 14.73 13.60 10.23





INFOTAINMENT 4 INFOBIP 5.27 6.50 6.34 5.90 7.38 6.78





INFOTAINMENT 4 INTEGRAT 2.32 1.46 1.71 1.80 2.67 3.55





INFOTAINMENT 4 INTERNAL - - - - - -





INFOTAINMENT 4 INTOMOBILE 7.69 6.33 6.63 5.69 5.29 3.72





INFOTAINMENT 4 IPCC - - - - - -





INFOTAINMENT 4 KLASSMT - - - - - -





INFOTAINMENT 4 LCF GLOBAL 3.00 2.43 1.98 1.65 1.87 2.16





INFOTAINMENT 4 MCOMM - - - - - -





INFOTAINMENT 4 MOBAFRIC - - - - - -





INFOTAINMENT 4 MOBILE XCETERA 25.63 21.89 20.49 22.60 35.24 47.29





INFOTAINMENT 4 MOBILISE AFRICA 7.06 5.86 5.93 5.58 5.08 4.64





INFOTAINMENT 4 MTECH 13.20 12.26 45.06 47.83 29.05 25.98





INFOTAINMENT 4 NEXTGEN - - - - - 0.01





INFOTAINMENT 4 NG MOBILE - - - - - -





INFOTAINMENT 4 NOK36 0.03 0.87 0.94 0.84 0.93 1.06





INFOTAINMENT 5 NOVAJI 0.01 - 0.05 0.04 - -





INFOTAINMENT 5 NTH 0.09 0.07 0.16 0.82 1.83 0.04





INFOTAINMENT 5 ONE97 - - 0.05 0.22 0.92 1.19





INFOTAINMENT 5 ONENUMBER 0.01 0.01 - 0.01 0.01 -





INFOTAINMENT 5 OPTIWEB 66.64 49.42 47.18 32.73 96.74 52.59





INFOTAINMENT 5 ORIONMOBILE 4.30 5.29 5.27 8.61 7.78 8.49





INFOTAINMENT 5 PETHAHIAH 12.66 14.49 19.05 18.47 17.45 14.35





INFOTAINMENT 5 PHOENIX 64.87 76.71 92.90 85.48 81.61 75.36





INFOTAINMENT 5 POLO SOLUTION - - - - - -





INFOTAINMENT 5 PRAEKELT - - - - - -





INFOTAINMENT 5 PROHUB - - - - - -





INFOTAINMENT 5 PROVECTUS 1.11 1.66 3.95 9.17 9.30 7.89





INFOTAINMENT 5 RANCARD 9.45 7.26 6.87 4.85 4.40 3.78





INFOTAINMENT 5 REMBRANDT 46.65 38.99 43.85 39.86 33.74 27.58





INFOTAINMENT 5 SAMSSON 55.74 50.82 49.40 40.92 39.59 33.79





INFOTAINMENT 5 SERGIO - - - - - -





INFOTAINMENT 5 SMARTLOAD 2.10 1.97 2.54 2.39 1.44 -





INFOTAINMENT 5 SPEXWEB 6.68 6.24 8.14 13.46 17.63 15.33





INFOTAINMENT 6 SPICE AFRICA 183.23 162.65 186.87 142.64 142.15 108.81





INFOTAINMENT 6 SPONGE 0.03 0.03 0.02 0.01 0.01 0.01





INFOTAINMENT 6 STARFISH 18.62 17.90 11.37 20.77 28.43 22.45





INFOTAINMENT 6 SUNYCH 7.56 8.34 6.71 - - -





INFOTAINMENT 6 SYMBIOTIC INFOTECH - - - - - -





INFOTAINMENT 6 TA TELECOM - - - - - -





INFOTAINMENT 6 TA TELECOMS - - - - - -





INFOTAINMENT 6 TAIVASMT - - - - - -





INFOTAINMENT 6 TELEMAGIC - - - - - -





INFOTAINMENT 6 TELSIS - - - - - -





INFOTAINMENT 6 TERRAGON 10.11 7.18 8.34 7.12 6.31 5.65





INFOTAINMENT 6 TEXTNIGERIA 13.66 12.04 12.76 11.59 11.52 9.99





INFOTAINMENT 6 TIG - - - - - -





INFOTAINMENT 6 VANSO - - - - - -





INFOTAINMENT 6 VAS2NET 7.40 3.62 3.00 1.03 0.59 0.43





INFOTAINMENT 6 VASDEV - - - - - -





INFOTAINMENT 6 VASDIG - - - 0.01 - 0.48





INFOTAINMENT 6 VAXTRIMT - 0.09 2.44 3.27 3.44 4.85





INFOTAINMENT 7 WINGTECH 2.11 10.60 33.39 59.96 61.18 45.54





INFOTAINMENT 7 XUME 23.79 22.10 26.15 33.54 41.27 34.84





INFOTAINMENT 7 YELLOW DOT 9.08 12.54 18.66 16.93 14.34 12.09





JOBS MTECH 48.32 40.57 37.88 33.34 34.01 29.95





JOBS SMARTLOAD 0.32 0.29 0.29 0.24 0.13 -





LOTTERY CELLCAST - - - - - -





LOTTERY HUMBER - - - - - -





MAGRIC VAS2NET 0.02 0.01 0.01 0.01 0.02 0.03





MEDICAL ADNOL - - - - - -





MFS 1 ACCESS BANK 0.02 0.02 0.01 0.01 0.01 0.01





MFS 1 CELLULANT - - - - - -





MFS 1 CLICKATELL 1.53 5.66 10.32 7.84 8.26 9.7





MFS 1 EARTHO - - - - - -





MFS 1 ELSEJI - 0.36 0.43 0.39 0.38 0.37





MFS 1 ETRANZACT 0.74 0.87 0.98 0.79 0.91 0.97





MFS 1 FETS - - - - - -





MFS 1 FORTIS 0.02 0.04 0.04 0.05 0.10 0.12





MFS 1 INTERSWITCH 0.26 0.27 0.30 0.26 0.30 0.34





MFS 1 INTOMOBILE - - - 0.02 0.10 0.07





MFS 1 IP INTEGRATED - - - - - -





MFS 2 MINES - - - - - -





MFS 2 NOVACREST - - - - - -





MFS 2 PAGATE 0.10 0.08 0.08 0.08 0.08 0.07





MFS 2 PARKWAY PROJECTS - - - - - -





MFS 2 PAYCOM 0.03 0.02 0.02 0.02 0.02 0.02





MFS 2 QRIOS 1.58 1.94 2.13 1.97 2.83 3.42





MFS 2 TEXTNIGERIA - - - - - -





MFS 2 VAS2NET 3.44 3.57 3.90 3.26 3.42 4.31





MFS 2 WEMABANK 0.32 0.38 0.37 0.34 0.41 0.44





MHEALTH ADNOL - - - - - -





MHEALTH CLOUD 7.64 7.78 10.30 8.39 6.50 4.1





MHEALTH HEALTH STRATEGIES - - 0.64 3.98 7.09 7.36





MHEALTH MEDHZ - - - - - -





MHEALTH VAS2NET 0.01 0.01 2.59 0.03 0.05 0.06





MHEALTH YELLOW DOT 1.18 1.10 1.09 1.03 0.96 0.89





MUSIC NAIJASOUND - - - - - -





MUSIC PETHAHIAH 0.14 0.10 0.11 0.14 0.07 -





MUSIC TIMWE 26.00 17.59 17.43 39.05 105.98 92.32





PORTAL TMAGIC - - - - - -





PORTAL VASDIG - - 1.04 2.63 1.13 0.89





PROMO CLOUD 311.63 221.81 202.97 161.42 126.92 113.61





PROMO TIMWE 112.26 92.19 101.13 107.57 139.87 179.85





RBT LCF GLOBAL 1.96 1.50 1.41 1.23 1.08 0.96





RELATIONSHIP EDENTEK 1.17 1.10 0.71 0.56 0.67 0.1





RELIGION AGILENT 0.22 0.17 0.16 0.13 0.10 0.1





RELIGION CLOUD 4.22 3.84 4.07 3.78 3.81 3.57





RELIGION EDENTEK 0.54 0.48 0.35 0.27 0.32 0.04





RELIGION ELSEJI 0.06 0.05 0.05 0.04 0.05 0.04





RELIGION FREESIA - - - 0.39 0.89 1.51





RELIGION MCOMM 6.74 5.85 5.96 5.40 5.11 4.16





RELIGION MOBILISE AFRICA 8.83 10.40 9.73 9.63 9.60 8.1





RELIGION SPEXWEB 5.78 1.62 1.07 3.45 2.68 5.79





RELIGION SPICE AFRICA 26.19 30.52 29.36 23.45 21.25 18.85





RELIGION YELLOW DOT - - - 0.02 - -





SERVICE HUAWEI 235.89 196.81 224.05 212.93 199.35 204.9





SOCIAL MEDIA SUNYCH 2.02 0.05 4.01 13.69 12.49 11.52





SPORT EDENTEK - - 0.09 0.07 0.08 0.01





VIDEO 7COLORSDIGITAL - - 0.05 0.04 0.08 0.56





VIDEO EFLUXZ 0.14 0.10 0.10 0.11 0.05 -





VIDEO IMAGINARIUM - - - - - -





VIDEO NAZARA - - - - - -





VIDEO NTH - - - - 0.52 1.53





VIDEO OPTIWEB 31.41 44.00 35.27 37.79 28.26 29.09





VIDEO REMBRANDT 49.79 49.42 58.35 52.02 51.50 43.94





VOTING CELLCAST 0.88 0.81 0.85 0.72 0.68 0.63







Column1 (combo box1)- SERVICE TYPES: APP STORE, BETTING, BETTING, GAMES, ENTERTAINMENT, BETTING, GAMES, FOOTBALL, etc.

Clolumn2 (combo box 2): SERVICE PROVIDERS: TERRAGON, CLOUD, MTECH, NAZARA, CLOUD, NAZARA, BINBIT, BINBIT, HUAWEI, SPICE, ESKIMI, TIMWE, CLOUD, MTECH, NAZARA, etc.

Columns 3-14 are MONTHLY REVENUE data(figures) for each SERVICE TYPES and SERVICE PROVIDERS which I need to project on a column chart.

Please kindly help resolve these issues.

Thanks for your time and support.

Emmanuel.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member
Aug 02, 2017 at 05:00 PM
0

Hello Emmanuel.

I think it'll be better if you create an incident for SAP Support to take a look at this issue, as they can take a look at the XLF and assist you with the design of this dashboard.

Thanks

Raman

Share
10 |10000 characters needed characters left characters exceeded