Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to create stack bar chart using below data :-
Dimension 1 | =if(match(Brand,'BT','Plusnet','EE'),'BT Group',if(Brand='Total Market','Total Market')) |
Dimension 2 | Speed by dp v/s tp |
Measure 1 | Sum({<Brand = {'Total Market'}>}speed volume) / Sum({<Brand = {'Total Market'}>} total speed volume) |
Measure 2 | Sum({<Brand = {'BT','Plusnet','EE'}>}Speed Volume) |
For measure 2 , I want to show the stack bar chart on the below logic :-
Stack bar = BT group
Measure - Sum of speed volume
For example= speed volume sum is 100
BT group bar | 100 |
Copper | 20% |
SF1 | 60% |
>SF2 | 20% |
I wish to show the breakdown of my measure with respect to speed volumes (Copper, SF1, >SF2) like below :-
Can anyone please help ?
Thanks in advance
Hello,
Can anyone please help me on this ?
Thanks
Are you sure you need Two dimensions and Two Measures? As per your example you have only Two dimensions and One Measure. Is thould be possible.
Yes, I need two dimensions and two measures.
Thanks