Aggregation with minimum

[sowmyapai26]

I have a straight table with around 10 dimensions. I want to display 1 record with the min(value) based on a ID. Please help me to display just one record with minimum value as this has been a challenge rather than finding the min value itself.

[kaushiknsolanki]

Hi,

Can you share your expected output.

Let us know how you want that to be seen in the table.

[sowmyapai26]

Thanks for the reply.

I have attached( a picture )of the sample data that I have created and highlighted in yellow the kind of output I am looking for. I want the minimum sales to be displayed along with the other dimensions in a straight table. Note that there can be duplicate records signifying the multiple sales . Any help is highly appreciated.

Thank you,

Sowmya

[kaushiknsolanki]

Hi Sowmya,

In your example, you are showing only one line item in the chart. So just confirming is you want to have only one line in chart, which shows sales for the minimum year?

[sowmyapai26]

Yes I want only 1 line item and it should show the minimum sales Amount based on the model.

[kaushiknsolanki · Accepted solution]

Try this.

Create a new table with all dimensions and use the below expression to get minimum sales for the Model.

Sum({<Model = {"=Rank(Sum(Sales)*-1) = 1"}>}Sales)

[sowmyapai26 · Accepted solution]

Thanks for the reply. To complicate the query further if I need to find the min sales for a particular Make and model as well?