Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have below data :-
Area , Outlet, Sales
Area1, Outlet1, 10
Area2, outlet 2, 20
Area3, Outlet 3, 30
I want to achieve below in front end:-
Dimension | Sales
Area1 | 10
Area2 |20
Area3| 30
Outlet 1 |10
Outlet 2 |20
Outlet 2 | 30
The main challenge I am facing here is clubbing the two dimensions into single filter and secondly how can I sort the sales values with respect to Area and outlet in ascending order .
Can anyone please help ? I thought if using value list and create dummy dimension, but it is not static. In future we might get more values like outlet 4, outlet 5, area 4, area 5 and so on.
Thanks
I wouldn't do it within the UI else within the script, maybe with something like:
t: load Area as Name, 'Area' as Type, Sales resident Rawdata order by Sales;
concatenate(t) load Outlet as Name, 'Outlet' as Type, Sales resident Rawdata order by Sales;
- Marcus