Bar Chart expression (not calculated)

[#1]

Hi,

I have a set of calculated data which I would like to show them on chart. Column A contains Business functions and column B contains all weekly sales, Column C contains Regions. I want to write a chart expression that selects column A = 'Consumer' and displays all weekly sales from column B. The Dimension will be Regions.

Thanks in advance.

Jasmine

[brindlogcool · Accepted solution]

If i understand the requirement correctly you can use column A ,Column C in the dimension and the sales in the expression.

[iktrayanov]

In your chart use

Dimension >>>  Regions

Expression >>>> Sum({<A = {Consumer}>}sales)

[#4]

Hi,

Thank you for your response. I want to see if I'm able to make the selection (Column A = 'Consumer') in the expression.

Jasmine

[#5]

I don't want to get Sum of the Sales because I want to display as it is.

Thanks,

Jasmine

[iktrayanov]

It will display sales per Region

[iktrayanov]

If you want to show details don't use chart just use table box.

[brindlogcool]

As Ivan suggested you can display the data in table. Or you have pass the selection in expression.

[#9]

Thank you so much for quick responses.

Jasmine