Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

set expression for region wise sale

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..

13 Replies
srishsum2017
Creator
Creator

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

Sumit Kumar Srivastava
MK9885
Master II
Master II

If you are talking about displaying Sales value on chart you can hover over a bar and you'll see the sales.

Or

Untitled.png

check the box 'Values on Data Points' and the sales values would show up on bar.

Anonymous
Not applicable
Author

i am not talking about this..

i want show total sales by region ,country, state, and city chart.

MK9885
Master II
Master II

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.