Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
i need to find particular region or country sales.I am not getting how to write set expression to calculate sales.
please help me to find out..
prachi please specify where you want to show the sales value, if you want on bar chart so please use show data points property, otherwise you can use simple a table to show this
If you are talking about displaying Sales value on chart you can hover over a bar and you'll see the sales.
Or
check the box 'Values on Data Points' and the sales values would show up on bar.
i am not talking about this..
i want show total sales by region ,country, state, and city chart.
Use Country, Region, State, City and State as Dimensions.
In measure use Sum(Sales)
This would gives sales of all the dimensions with no filter.
but if you want specific filters, use set analysis.