list price by product name

[koorosh]

Hi All, How do create clustered column chart from DimProduct4 table with product name on X-axis and the ListPrice of each product on Y-axis?

[HotChilli · Accepted solution]

It is a clustered column chart so it will require an aggregation.  Some aggregations (MIN, MAX, SUM) will work if there is only one 'item' in the table for each product i.e. it'll use an aggregation but the result will be the same as if there was no aggregation. 

Some of this data has multiple items for each product but there is a field called Status which can be used to identify the Current (or active item).  So you can filter the visual by putting Status = Current in the filter pane. 

[HotChilli]

Can you explain a bit more about what problem you are having?

[koorosh]

Please check the following images. The Y-Axis is sum of ListPrice or count Listprice. I want to have the price of each product in the chart not count, sum or Ave.