i have a question about showing the data value in a bar chart. I want to show sales contribution from one Area (let's say Area A). Area A has total sales 5000 and total sales of ALL area is 20000. The contribution of Area A must be 5000/20000 --> 0.25 (25%) . but when i use bar chart (with area dimension) the result return 1, i use this formula --> sum({Area ={'A'}}sales) / sum(sales). anyone knows the solution ? really appreciate your help, thanks
In fact in your example you need to use TOTAL, because when you use Area as Dimension and reduce its values by Set Analysis as result sum( {<Area={'A'}>} Sales) equal sum(Sales) in the same expression. If you add new expression sum(Sales) there will not equal sum(Sales) in your first expression.
To understand more deeply this process find attach a bit modified example.
In fact in your example you need to use TOTAL, because when you use Area as Dimension and reduce its values by Set Analysis as result sum( {<Area={'A'}>} Sales) equal sum(Sales) in the same expression. If you add new expression sum(Sales) there will not equal sum(Sales) in your first expression.
To understand more deeply this process find attach a bit modified example.
