Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I got the below 2 bar-charts
I'm showing the revenue per region per year
the second bar chart shows the total revenue per year
is it possible to have the second graph to display the total on the first graph?
so Grouping is made on Region1, Region2, Region3 then Total
I did it
I found a tweak:
I created a dimension as followins in the script:
DIM:
load * inline [
DIM
1
2
];
then instead of adding the Region dimension, I added the following calculated dimension:
pick(DIM, Region, 'Total')
and here is the result:
I did it
I found a tweak:
I created a dimension as followins in the script:
DIM:
load * inline [
DIM
1
2
];
then instead of adding the Region dimension, I added the following calculated dimension:
pick(DIM, Region, 'Total')
and here is the result: