4 Replies Latest reply on Mar 15, 2017 2:11 AM by Ken Muir

# How do I find the FIRST value of a specific dimension

Hello Community

I have a problem that I've not been able to solve. I've simplified the data and attached a packaged workbook. I have multiple products that change position on a website at different dates. I can easily calculate the Average, Max and Min position of each product, but cannot find a way to calculate the First and Last position of each product. The first and last value has to linked to the "location in" date filter, i.e. changing the date will change the first position

So in the instance of the screen shot

• product 1 will return 372
• product 2 will return 331
• product 3 will return 43.

However if I filter the date from 17/02/2017;

• product 1 will return 345
• product 2 will return 333
• product 3 will return 88

Want to do the same with the location of the last date for each product as well. Any feedback appreciated!

Ken

• ###### 1. Re: How do I find the FIRST value of a specific dimension

Hi,

Try FIRST() and LAST() functions in calculated field and add the table calculation to restart every [Game]

Gourav

1 of 1 people found this helpful
• ###### 2. Re: How do I find the FIRST value of a specific dimension

Please find the workbook (9.3) attached along with the SS.

Gourav

• ###### 3. Re: How do I find the FIRST value of a specific dimension

I tried First but have never realised you can do table calculations before. I'll try it on the real data but it works well on this sample workbook, thanks!

• ###### 4. Re: How do I find the FIRST value of a specific dimension

Hi - The table calculation works when in the table, but I need the first location date of a product in dashboards that summarise the data, i.e. do not include the location in as a row. Is there any way of calculating the First date and Last Date of a product in the example as a calculated field? I have attached the sample file with the worksheet.